我要请高手们指教了,我怎么改啊



private void button4_Click(object sender, System.EventArgs e)
{
SqlConnection conn = new SqlConnection("server=aaa;database=human;uid=sa;password=sys1369");
conn.Open();
SqlCommand cd = new SqlCommand("update dept set dept='"+textBox1.Text+"',chief='"+textBox2.Text+"',tel='"+textBox3.Text+"',duty='"+textBox4.Text+"' where dept='"+textBox5.Text+"'",conn);
string message="确定修改吗？修改请按yes.";
string caption="提示信息!";
MessageBoxButtons buttons = MessageBoxButtons.YesNo;
DialogResult result;
result=MessageBox.Show(this,message,caption,buttons,MessageBoxIcon.Warning,MessageBoxDefaultButton.Button1,MessageBoxOptions.RightAlign);
if (result == DialogResult.Yes)
{
cd.ExecuteNonQuery();
conn.Close();
MessageBox.Show("修改成功!");
dataGrid1.Refresh();
}
}

System.Data.SqlClient类是专门用于访问SQLSERVER数据库的，如果要成ACCESS数据库要使用System.Data.OleDb类
using System.Data.OleDb;

private void button4_Click(object sender, System.EventArgs e)
{
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\somepathmyDb.mdb;User Id=sa;Password=sys1369;");

conn.Open();
OleDbCommand cd = new OleDbCommand("update dept set dept='"+textBox1.Text+"',chief='"+textBox2.Text+"',tel='"+textBox3.Text+"',duty='"+textBox4.Text+"' where dept='"+textBox5.Text+"'",conn);
string message="确定修改吗？修改请按yes.";
string caption="提示信息!";
MessageBoxButtons buttons = MessageBoxButtons.YesNo;
DialogResult result;
result=MessageBox.Show(this,message,caption,buttons,MessageBoxIcon.Warning,MessageBoxDefaultButton.Button1,MessageBoxOptions.RightAlign);
if (result == DialogResult.Yes)
{
cd.ExecuteNonQuery();
conn.Close();
MessageBox.Show("修改成功!");
dataGrid1.Refresh();
}
}

谢谢楼上的兄弟啊呀

就是这样。

dataGrid1.Refresh();
我把这个换成几个textBox应该这么做了呢

楼上老兄，好好看看再说吧，你底子太差