DataAdapter Update method throws DBConcurrencyException

[Ahmed]

I am having this problem with an application which seems to call
DBConcurrencyException when calling the Update Method to my DataAdapter.
It seems to happen only when I add a new record to my DataTable and this is
the first row, if I have 2 rows the exception is not thrown. I really do not
know how to fix this problem, here is the flow to my application.
App Start -> Fill DataTable (Lets say it fill 0 records for the example) ->
Add new DataRow to Datatable -> Call DataAdapter Update Method (checked DB
after Update and it is there) -> Delete method called on DataRow from
DataTable -> Update method called on DataAdapter -> Exception thrown.
If the application fills 1 or more records initially the exception is not
thrown but why??
I do not know if I have been clear enough but I hope someone can help me
out!

TIA,
Ahmed

 

[Jon Skeet [C# MVP]]

I am having this problem with an application which seems to call
DBConcurrencyException when calling the Update Method to my DataAdapter.
It seems to happen only when I add a new record to my DataTable and this is
the first row, if I have 2 rows the exception is not thrown. I really do not
know how to fix this problem, here is the flow to my application.
App Start -> Fill DataTable (Lets say it fill 0 records for the example) ->
Add new DataRow to Datatable -> Call DataAdapter Update Method (checked DB
after Update and it is there) -> Delete method called on DataRow from
DataTable -> Update method called on DataAdapter -> Exception thrown.
If the application fills 1 or more records initially the exception is not
thrown but why??
I do not know if I have been clear enough but I hope someone can help me
out!

What exactly is the exception? What's the message in it?