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

hi all.
i've just encountered a problem in C#:

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

that is an exception raised when there is a mismatch between the time that the DataTable reads from the DB until the time it wants to update it.

one can use 2 functions: dataAdapter.Fill(dataTable) and dataAdapter.Update(dataTable)

my problem was that i 1st made Fill(), then made changes to the table, than 2nd made Update(). until now it worked perfect. now when i want to make further Update() calls i get this Exception.

after some hours...i've figured out that all u need to do is use dataTable.Clear() and than call the Fill() method again and it works perfect!