SqlDataAdapter Update Functionality

Apart from SqlDataAdapter, datatable1.GetChanges(..) is the only way to update the modification, when user make any changes xx.GetChanges(..) function will extract only the changes row not the whole row in case of SqlDataAdapter. On your next/prev button, call and update your table accordingly.

0

Deepa Lomte6y ago

I have a 3 page form. On Next / Previous buttons, I am saving data in database. For saving data I have used DataAdapter Update method, which either insert or update data, as I dont know state of the record. So I want an alternative method which behaves like DataAdapter Update method but solve my perfomance issue too.

So Can anybody help me ?

0

Amit Gupta6y ago

Yeah, if you have much more data then you might have performance issue, alternatively you can use like

var data = dataTable1.GetChanges(..);

you will get different rows like modified, added and deleted, perform the operation based on that.

Do let me know, if you require any clarification.

-1