Loading

SqlDataAdapter for Inserting and Deleting records in DB

Deepa Lomte

Hi,

I am using Data Adapter Update command for inserting records in database. Now I want to delete few records and insert records in database which are in Datatable.

How do I achieve both actvities using SqlAdapter.Update methods in single click.

Thanks

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Gupta6y ago
datatable.AcceptChanges(); Call the above function before calling the update function.
Deepa Lomte6y ago
Yes I did the same. But unfortunately its not deleting the records from database
Amit Gupta6y ago
SqlAdapter can perform all CRUD operations, do all your stuffs like insertion, deletion on that datatable and just call the below code
SqlCommandBuilder builder = new SqlCommandBuilder(adapter);
int val = adapter.Update(datatable);