public DataSet updateData (DataSet myDataSet,
string connString, string query) {
OleDbConnection myConn = new OleDbConnection (connString);
OleDbDataAdapter adapter = new OleDbDataAdapter ();
adapter.SelectCommand = new OleDbCommand (query, myConn);
OleDbCommandBuilder custCB = new OleDbCommandBuilder (adapter);
DataSet myDataSet = new DataSet ();
myConn.Open();
adapter.Fill (myDataSet);
// ... code to modify data in dataset here ...
// without the OleDbCommandBuilder this line would fail
adapter.Update(myDataSet);
myConn.Close();
return myDataSet;
}
Public Function updateData (myDataSet As DataSet, _
connString As String, query As String)
Dim myConn As New OleDbConnection (connString)
Dim adapter As New OleDbDataAdapter ()
adapter.SelectCommand = New OleDbCommand (query, myConn)
Dim custCB As New OleDbCommandBuilder (adapter)
Dim myDataSet As DataSet = New DataSet
myConn.Open()
adapter.Fill (myDataSet)
' ... code to modify data in DataSet here ...
' without the OleDbCommandBuilder this line would fail.
adapter.Update(myDataSet)
myConn.Close()
updateData = myDataSet
End Function