Hi

I have a strange probelem.

My form only inserts into the database.

To get all the table adapters etc on my form, I drag on the required database table from Data Sources then remove the binding navigator strip.

In the auto generated form-load procedure I add a

• myTableBindingSource.AddNew()
• and initialise the new record.
• end the form load procedure.

Then allow the user to input data in the form

• check all data is valid and all keyed in
• save using myTableAdapter.Update

This works on all except the first attempt at insert which inserts a blank row and form fails with "Concurrency violation: the UpdateCommand affected 0 of the expected 1 records2.
When I re-run the project - subsequent rows are inserted OK. The inital blank row is not updated and subsequent re-starts of the project to add more data does not overwirte any rows.

My initial table is empty.

Is there something I need to do to insert a first row in a datatable rather than AddNew?

__________________
Pat