SqlDataAdapter Update Functionality

Question

Hi, I am using SqlDataAdapter.Update method to Insert/Update or Delete data from a table. But I am experincing performance issue by using this. Can you suggest any better method to achieve Insert / Update or Delete records of a user in single event. Table size is more. Thanks in advance.

Amit Gupta · Answer

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.

Deepa Lomte · Answer

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 ?

Amit Gupta · Answer

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.

SqlDataAdapter Update Functionality

Answers (3)