怎样通过DataGrid更新数据库？

Question

http://www.chinabs.net/aspnet/default.asp?infoid=48

Answer 1

建立一个SqlCommandBuilder对象,然后MyDataAdapter.Update函数即可更新到数据库然后AcceptChanges

Answer 2

to bigrongshu:
能具体点么？有没有例子？

Answer 3

try
 {
   OleDbConnection dbConn = new OleDbConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
   OleDbDataAdapter dbAdapt = new OleDbDataAdapter(sql,dbConn);
   OleDbCommandBuilder dbCB = new OleDbCommandBuilder(dbAdapt);   dbConn.Open();
   DataSet dbSet = new DataSet();
   dbAdapt.Fill(dbSet, "tblFile");
   DataTable dbTable = dbSet.Tables["tblFile"];
......
 ......
   dbAdapt.Update(dbSet, "tblFile");
   grid1.EditItemIndex=-1;
   show_del("show");
   Dataload("location_id"); 
}
  catch(OleDbException ex)
 {
    info.Text=ex.Message;
 }