DataGridView 同步更新到数据库 一。绑定数据 SqlConnection con = null; SqlDataAdapter sa = null; SqlCommandBuilder sb = null; DataTable dt = null; BindingSource bs = null; 窗体时绑定数据 private void DataBingding_Load(object sender, EventArgs e) { con = new SqlConnection("server=.;uid=sa;pwd=sa;database=pubs;"); try { con.Open(); sa = new SqlDataAdapter("select * from jobs", con); sb = new SqlCommandBuilder(sa);//绑定 SqlDataAdapter dt = new DataTable(); sa.Fill(dt); this.dataGridView1.DataSource = dt; 

bs = new BindingSource(); bs.DataSource = dt;//绑定 BindingSource con.Close(); } catch (Exception ex) { con.Close(); throw ex; } } SqlConnection con = null; SqlDataAdapter sa = null; SqlCommandBuilder sb = null; DataTable dt = null; BindingSource bs = null; //加载窗体时绑定数据 private void DataBingding_Load(object sender, EventArgs e) { con = new SqlConnection("server=.;uid=sa;pwd=sa;database=pubs;"); try { 

con.Open(); sa = new SqlDataAdapter("select * from jobs", con); sb = new SqlCommandBuilder(sa);//绑定 SqlDataAdapter dt = new DataTable(); sa.Fill(dt); this.dataGridView1.DataSource = dt; bs = new BindingSource(); bs.DataSource = dt;//绑定 BindingSource con.Close(); } catch (Exception ex) { con.Close(); throw ex; } } 二.同步 DataGridView 数据到数据库

//更新 按钮单击事件

private void button1_Click(object sender, EventArgs e)

{



sa.Update((DataTable)bs.DataSource); }