界面上編輯DataGridView同步更新到數(shù)據(jù)庫

一。綁定數(shù)據(jù)

??????SqlConnection?con?=?null;

????????SqlDataAdapter?sa?=?null;

????????SqlCommandBuilder?sb?=?null;

????????DataTable?dt?=?null;

????????BindingSource?bs?=?null;

//加載窗體時綁定數(shù)據(jù)

????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數(shù)據(jù)到數(shù)據(jù)庫

//更新?按鈕單擊事件

????????private?void?button1_Click(object?sender,?EventArgs?e)

????????{

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

????????}