public static DataSet UpdateRows(string connectionString, string queryString, string tableName) { DataSet dataSet = new DataSet(); using (OleDbConnection connection = new OleDbConnection(connectionString)) { OleDbDataAdapter adapter = new OleDbDataAdapter(); adapter.SelectCommand = new OleDbCommand(queryString, connection); OleDbCommandBuilder cb = new OleDbCommandBuilder(adapter); connection.Open(); adapter.Fill(dataSet, tableName); //code to modify data in DataSet here //Without the OleDbCommandBuilder this line would fail adapter.Update(dataSet, tableName); connection.Close(); } return dataSet; }
OleDbCommandBuilder
最新推荐文章于 2019-03-21 10:44:47 发布