OleDbAdapter.Update failure

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Pavel Gusak

    #1

    OleDbAdapter.Update failure

    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 ();
    }


Working...