Question Insert Row error, wrong row still in dataset

[bavelt]

Hello,
I've got a (perhaps simple) problem and found still no solution yet.

I've learned for adding records to an Access Database to use both the dataAdapter and Dataset.

When I insert a row in the dataset, it will be physibally updated in the database by the "update command (da.Update)"

But when this returns an error (key alreays exists in the database), the wrong row is still in the dataset! And that keeps giving the error for every further update on that database.

The question is: how do I get rid of the wrong row in the dataset?

Bavelt

 

[jmcilhinney]

You use the Add method to add a DataRow to a DataTable and you use the Remove method to remove it.