DataSet是存在記憶體中的對象,DataAdapter是與資料庫連接配接資訊相關的。
是以要批量更新一個DataSet,需要借助DataAdapter.
static private DataSet CreateCommandAndUpdate( string connectionString, string queryString) { DataSet dataSet = new DataSet(); using (OleDbConnection connection = new OleDbConnection(connectionString)) { connection.Open(); OleDbDataAdapter adapter = new OleDbDataAdapter(); adapter.SelectCommand = new OleDbCommand(queryString, connection); OleDbCommandBuilder builder = new OleDbCommandBuilder(adapter); adapter.Fill(dataSet); // Code to modify data in the DataSet here. // Without the OleDbCommandBuilder, this line would fail. adapter.UpdateCommand = builder.GetUpdateCommand(); adapter.Update(dataSet); } |