Feb 3, 2011

Concurrency violation: the UpdateCommand affected 0 of the expected 1 records

I was updating database using DataAdapter.Update method and got following error:

System.Data.DBConcurrencyException: Concurrency violation: the UpdateCommand affected 0 of the expected 1 records.

I was updating 2-3 columns of tables (having 20 columns) and expected to update those columns only. I fixed the problem and decided to write on it.