DataAdapter update - not working

[Shahar]

Hi
Why this code does not updated the DB, just the DataSet:

DataSet ds = new DataSet();

OleDbDataAdapte r adapter = new OleDbDataAdapte r("Select * from
Employees", @"Provider=Micr osoft.Jet.OLEDB .4.0;Data Source=My.mdb") ;
adapter.Fill(ds , "Employees" );

ds.Tables["Employees"].Rows[0].BeginEdit();
ds.Tables["Employees"].Rows[0]["name"] = "X";
ds.Tables["Employees"].Rows[0].EndEdit();

ds.AcceptChange s();
adapter.Update( ds, "Employees" );

foreach(DataRow row in ds.Tables["Employees"].Rows)
{
Console.WriteLi ne(row["id"] + " " + row["name"]);
}
}
catch(Exception exp)
{
Console.WriteLi ne(exp.Message. ToString());
}

[Eliyahu Goldin]

Get rid of ds.AcceptChange s();

AcceptChanges commits changes to the dataset. All added and modified rows
become "Unchanged" , and, when you call Update (..), the data adapter doesn't
find any modified rows to update. Update () calls AcceptChanges ()
internally.

Hope this helps,

Eliyahu

"Shahar" <sh****@log-on.com> wrote in message
news:e8******** *************** ***@posting.goo gle.com...

Hi
Why this code does not updated the DB, just the DataSet:

DataSet ds = new DataSet();

OleDbDataAdapte r adapter = new OleDbDataAdapte r("Select * from
Employees", @"Provider=Micr osoft.Jet.OLEDB .4.0;Data Source=My.mdb") ;
adapter.Fill(ds , "Employees" );

ds.Tables["Employees"].Rows[0].BeginEdit();
ds.Tables["Employees"].Rows[0]["name"] = "X";
ds.Tables["Employees"].Rows[0].EndEdit();

ds.AcceptChange s();
adapter.Update( ds, "Employees" );

foreach(DataRow row in ds.Tables["Employees"].Rows)
{
Console.WriteLi ne(row["id"] + " " + row["name"]);
}
}
catch(Exception exp)
{
Console.WriteLi ne(exp.Message. ToString());
}