本文整理汇总了C#中System.Data.OleDb.OleDbCommandBuilder类的典型用法代码示例。如果您正苦于以下问题：C# OleDbCommandBuilder类的具体用法？C# OleDbCommandBuilder怎么用？C# OleDbCommandBuilder使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
OleDbCommandBuilder类属于System.Data.OleDb命名空间，在下文中一共展示了OleDbCommandBuilder类的2个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: UpdateRows
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
cb.GetDeleteCommand();
//Without the OleDbCommandBuilder this line would fail
adapter.Update(dataSet, tableName);
connection.Close();
}
return dataSet;
}示例2: new OleDbCommandBuilder
//引入命名空间
using System;
using System.Data;
using System.Data.OleDb;
public class UpdatingADataSource
{
static void Main(string[] args)
{
OleDbConnection MyConnection = new OleDbConnection(@"Provider=Microsft.Jet.OLEDB.4.0; Data Source = c:\MyAccessDB.mdb");
OleDbDataAdapter MyAdapter = new OleDbDataAdapter("SELECT Column1, Column2, Column3 FROM MyTable", MyConnection);
DataSet MyDataSet = new DataSet();
MyAdapter.Fill(MyDataSet, "MyTable");
MyDataSet.Tables[0].Rows[3]["Column3"] = "Test";
OleDbCommandBuilder MyBuilder = new OleDbCommandBuilder(MyAdapter);
MyAdapter.Update(MyDataSet.Tables[0]);
}
}