ارجو المساعدة في تحديث dataGridView

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

using MySql.Data.MySqlClient;

using System.IO;

using System.Drawing.Imaging;

namespace Contacts

{

public partial class frmManagers : Form

{

DataSet ds = new DataSet();

MySqlConnection MySqlCon = new MySqlConnection("Server=localhost;Database=mysql;userid =root;password=MJ@1234");

MySqlDataAdapter da = new MySqlDataAdapter();

MySqlConnection cn;

MySqlCommand cmd;

MemoryStream ms;

public frmManagers()

{

InitializeComponent();

}

public static string txtManager_Name;

public static string aduStatus;

public static int intManager_ID;

private void btnSave_Click(object sender, EventArgs e)

{

}

private void frmManagers_Load(object sender, EventArgs e)

{

if (frmAddAdvances.SelectManger == "Yes")

{

btnAdd.Enabled = false;

btnUpdate.Enabled = false;

btnDelete.Enabled = false;

}

else

{

btnAdd.Enabled =true;

btnUpdate.Enabled = true;

btnDelete.Enabled = true;

}

da.SelectCommand = new MySqlCommand("SELECT Manager_ID,Manager_Name,Position FROM Managers", MySqlCon);

//txtFirstName.DataBindings.Clear();

//txtLastName.DataBindings.Clear();

ds.Clear();

da.Fill(ds);

dgM.DataSource = ds.Tables[0];

//dgM.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;

DataGridViewColumn columnManagerName = dgM.Columns[1];

DataGridViewColumn columnPosition = dgM.Columns[2];

columnManagerName.Width = 130;

columnPosition.Width = 130;

//dgM.AutoSize = true;

// tblNamesBS.DataSource = ds.Tables[0];

// txtFirstName.DataBindings.Add(new Binding("Text", tblNamesBS, "Doc_Num"));

// txtLastName.DataBindings.Add(new Binding("Text", tblNamesBS, "Manager_Name"));

////textBox1.DataBindings.Add(new Binding("Text", tblNamesBS, "Last_Name"));

}

private void btnAdd_Click(object sender, EventArgs e)

{

cn = new MySqlConnection("Server=localhost;Database=mysql;userid =root;password=MJ@1234");

//cmd = new MySqlCommand("SELECT * FROM Advances WHERE Doc_Num = '" + dg.se+ "'", cn);

cmd = new MySqlCommand("SELECT MAX(Manager_ID)+1 FROM Managers", cn);

cn.Open();

MySqlDataReader dr;

try

{

dr = cmd.ExecuteReader();

if (dr.Read())

{

intManager_ID = Convert.ToInt16(dr[0]);

//MessageBox.Show(intManager_ID.ToString());

}

}

catch (Exception ex)

{

MessageBox.Show(ex.Message);

}

finally

{

cn.Close();

}

//intManager_ID = Convert.ToInt16(dgM.CurrentRow.Cells[0].Value);

txtManager_Name = "";

aduStatus = "Add";

frmAddManagers formAddManagers = new frmAddManagers();

formAddManagers.Show();

//textBox1.Text = dgM.CurrentRow.Cells[1].Value.ToString();

//MessageBox.Show(txtManager_Name);

}

private void dgM_CellContentClick(object sender, DataGridViewCellEventArgs e)

{

}

الفورم الثاني

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

using MySql.Data.MySqlClient;

using System.IO;

namespace Contacts

{

public partial class frmAddManagers : Form

{

string aduStatus;

DataSet ds = new DataSet();

MySqlConnection MySqlCon = new MySqlConnection("Server=localhost;Database=mysql;userid =root;password=MJ@1234");

MySqlDataAdapter da = new MySqlDataAdapter();

BindingSource tblNamesBS = new BindingSource();

MySqlConnection cn;

MySqlCommand cmd;

MemoryStream ms;

public frmAddManagers()

{

InitializeComponent();

}

private void textBox1_TextChanged(object sender, EventArgs e)

{

}

private void AddManagers_Load(object sender, EventArgs e)

{

aduStatus = frmManagers.aduStatus;

//MessageBox.Show(aduStatus);

txtManagerName.Text = frmManagers.txtManager_Name;

txtManagerID.Text = frmManagers.intManager_ID.ToString();

}

private void btnSave_Click(object sender, EventArgs e)

{

if (aduStatus == "Add")

{

da.InsertCommand = new MySqlCommand("INSERT INTO Managers (Manager_Name ,Position) VALUES (@Manager_Name ,@Position)", MySqlCon);

da.InsertCommand.Parameters.Add("@Manager_Name", MySqlDbType.VarChar).Value = txtManagerName.Text;

da.InsertCommand.Parameters.Add("@Position", MySqlDbType.VarChar).Value = txtPosition.Text;

if (txtManagerName.Text != "")

{

MySqlCon.Open();

da.InsertCommand.ExecuteNonQuery();

MySqlCon.Close();

ClearTextBoxes(this);

}

else

{

MessageBox.Show("You cannot insert empty name to managers table");

}

}

private void button1_Click(object sender, EventArgs e)

{

this.table1TableAdapter.Update(this.dataset1.table1);

MessageBox.Show("تم الحفظ شكرا");

}