I'm trying to update Access database with data from DataSet in my Web
Service.
Does not work. Generates Concurrency violation error, however, nobody works
with db at the time.
Can you help me?
The code is below.
Thanks.
protected void DataSetUpdate(D ataSet ds, string tableName)
{
OleDbDataAdapte r adapter;
OleDbCommandBui lder builder;
string selectCommand = "SELECT * FROM " + tableName;
adapter = new OleDbDataAdapte r(selectCommand , conn);
builder = new OleDbCommandBui lder(adapter);
adapter.InsertC ommand = builder.GetInse rtCommand();
adapter.UpdateC ommand = builder.GetUpda teCommand();
adapter.DeleteC ommand = builder.GetDele teCommand();
//adapter.Continu eUpdateOnError = true;
adapter.Update( ds, tableName);
adapter.Dispose ();
}
Service.
Does not work. Generates Concurrency violation error, however, nobody works
with db at the time.
Can you help me?
The code is below.
Thanks.
protected void DataSetUpdate(D ataSet ds, string tableName)
{
OleDbDataAdapte r adapter;
OleDbCommandBui lder builder;
string selectCommand = "SELECT * FROM " + tableName;
adapter = new OleDbDataAdapte r(selectCommand , conn);
builder = new OleDbCommandBui lder(adapter);
adapter.InsertC ommand = builder.GetInse rtCommand();
adapter.UpdateC ommand = builder.GetUpda teCommand();
adapter.DeleteC ommand = builder.GetDele teCommand();
//adapter.Continu eUpdateOnError = true;
adapter.Update( ds, tableName);
adapter.Dispose ();
}