Dataset与DataAdapter

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);

}

return dataSet;

}

这样的机制也带来一个好处，比如我们想要从一个数据库中取出数据，更新到另一个数据库中去，就可以借助Dataset作为一个中间载体。