I am trying to change some of the data after calling
dataadapter.update() and before insert to database by catching it in a
OleDbRowUpdatedEventHandler. I can red the data and change it in the event handler but it dose not change the fileds whene updateing the database!!!
:-(
my code is:
static void da_OnRowUpdate(object sender, OleDbRowUpdatedEventArgs e)
{
e.Row[1] =
"test 1";
e.Row.AcceptChanges();
}
private void updateDB2()
{
OleDbConnection cnn = new OleDbConnection(conStr);
OleDbDataAdapter da = new OleDbDataAdapter("SELECT * FROM parts", cnn);
da.RowUpdated += new OleDbRowUpdatedEventHandler(da_OnRowUpdate);
OleDbCommandBuilder MyCmd = new OleDbCommandBuilder(da);
da.Update(dsParts , "parts");
cnn.Close();
}