下面是DataTable与dataGridView 控件绑定，当dataGridView中的数据改变时，更新数据库的代码：
DataTable和dataGridView控件绑定代码：
private void Form1_Load(object sender, EventArgs e)
{
string sqlConnectionString = "Data Source=ComputerName-PC;Initial Catalog=charge_sys;User ID=sa;PWD=123456;";
SqlConnection sqlConnection = new SqlConnection(sqlConnectionString);//初始化sqlconnection
DataTable table = new DataTable();
SqlDataAdapter sqlAdap = new SqlDataAdapter("select * from testB ", sqlConnection);
sqlConnection.Open();
sqlAdap.Fill(table);
sqlConnection.Close();
//将testB表中的数据显示在dataGridView中
this.dataGridView1.DataSource = table;
}
实现将dataGridView中的改动更新到数据库代码：
private void butUpdate_Click(object sender, EventArgs e)
{
DataTable table = new DataTable();
table = (DataTable)this.dataGridView1.DataSource;
string sqlConnectionString = "Data Source=WangHaitao-PC;Initial Catalog=charge_sys;User ID=sa;PWD=123456;";
SqlConnection sqlConnection = new SqlConnection(sqlConnectionString);
SqlCommand sqlCommand = new SqlCommand("select * from testB", sqlConnection);
SqlDataAdapter sqlAdap = new SqlDataAdapter(sqlCommand);
SqlCommandBuilder sqlBuilder = new SqlCommandBuilder(sqlAdap);//必须有
sqlConnection.Open();
sqlAdap.Fill(table);
//testB表中必须存在主键，否则无法更新
sqlAdap.Update(table);
sqlConnection.Close();
MessageBox.Show("aa");
}