Posted on 2004-08-22
I am accessing an access database with a couple tables in it, i created data adapters for all the tables and i made one dataset with all the tables in it, probably not the best, but it works. I have a 1-many relationship with my employees and available tables. when i change the available table then call the
Update(dataset, "tablename") method I get a System.Data.DBConcurrencyException.
I thought maybe I was passing bad data, so i just tried deleting a row from the table...
dataset.tables["available"].Rows.Delete(); then called the update...
Adapter.Update(dataset,"table"); and i get the same exception. When I do this it gives me additional information: Concurrency violation: the DeleteCommand affected 0 records.