与数据库连接的问题

Question

Updatecommand的语句怎么用

Answer 1

DataSet ds；
// 创建数据库连接
   conn = new OleDbConnection(strConn);
   // 创建DataAdapter和CommandBuilder
   adapter = new OleDbDataAdapter(strSql, conn);
   commBuilder = new OleDbCommandBuilder(adapter);
   adapter.InsertCommand = commBuilder.GetInsertCommand();
   adapter.DeleteCommand = commBuilder.GetDeleteCommand();
   adapter.UpdateCommand = commBuilder.GetUpdateCommand();
   conn.Open();
   // 更新数据库
   adapter.Update(ds);就O了，当然OleDbConnection可以换成SqlConnection.

Answer 2

updatecommand其实质还是设置"Update"更新语句。