Concurrency violation in DataAdapter.Update

Question

Hi I am getting the concurrency violation when I'm updating the data for the second time. First time everything goes smooth and gets updated to oracle database. I am calling ApplyingChanges also after the first update. Even though the row state is modified for the second update and old row and current row show the right value it is throwing exception. Regards Pradeep

Andrzej Wegierski · Answer

What about spaces in the end of fields? They should cause this error. For instance You add xxx key. It works. But there is xxx  in database. Update failed. Next - additional AcceptChanges between updates can modify row status and generate thesame error. For instance row is added. AcceptChanges modifies status to not modified. Modifying the field changes status to modified - but there's no such row in database. Update failed. Check Your code.