public DataTable CreateCmdsAndUpdate(DataSet myDataSet,string myConnection,string mySelectQuery,string myTableName)
{
OleDbConnection myConn = new OleDbConnection(myConnection);
OleDbDataAdapter myDataAdapter = new OleDbDataAdapter();
myDataAdapter.SelectCommand = new OleDbCommand(mySelectQuery, myConn);
OleDbCommandBuilder custCB = new OleDbCommandBuilder(myDataAdapter); myConn.Open(); DataTable custDT = new DataTable();
myDataAdapter.Fill(custDT); //code to modify data in DataTable here //Without the OleDbCommandBuilder this line would fail
myDataAdapter.Update(custDT); myConn.Close(); return custDT;
}在msdn上的dbdataadapter class 中的例程
{
OleDbConnection myConn = new OleDbConnection(myConnection);
OleDbDataAdapter myDataAdapter = new OleDbDataAdapter();
myDataAdapter.SelectCommand = new OleDbCommand(mySelectQuery, myConn);
OleDbCommandBuilder custCB = new OleDbCommandBuilder(myDataAdapter); myConn.Open(); DataTable custDT = new DataTable();
myDataAdapter.Fill(custDT); //code to modify data in DataTable here //Without the OleDbCommandBuilder this line would fail
myDataAdapter.Update(custDT); myConn.Close(); return custDT;
}在msdn上的dbdataadapter class 中的例程
...OleDbConnection conn = new OleDbConnection("Provider=MSDAORA.1;User ID=uid;Password=pwd;Data Source=db");
conn.Open();
OleDbDataAdapter da = new OleDbDataAdapter("select ...", conn);
DataTable dt = new DataTable();
da.Fill(dt);