myConn = new OleDbConnection(connStr); myDataAdapter = new OleDbDataAdapter(); myDataAdapter.SelectCommand = new OleDbCommand("SELECT * FROM TABLE", myConn); myCommandBuilder = new OleDbCommandBuilder(myDataAdapter);myConn.Open(); myDataAdapter.Update(myDataSet.Tables[0].GetChanges()); myConn.Close();
你看一下系统生成的代码就明白了,他不是只有那两行的,
myDataAdapter = new OleDbDataAdapter();
myDataAdapter.SelectCommand = new OleDbCommand("SELECT * FROM TABLE", myConn);
myCommandBuilder = new OleDbCommandBuilder(myDataAdapter);myConn.Open();
myDataAdapter.Update(myDataSet.Tables[0].GetChanges());
myConn.Close();