Bulk update with a stored procedure ?

Morcos Adel

15y6.7k

Hi...
actually i am working on a performance issue,i have a 1000 record in a gridview in a web page and i am allowing the editing of the data and when a save button is clicked i want to update the records in the database again using a stored procedure is there another way to update my database without fetching each row of the gridview in the update process??
i mean can i just pass a datatable or something to the sqlserver in the stored procedure parameters and then it updates it self ????
thanks in advance

4 Replies

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

Satish Bhat15y ago
Accepted answer
1] You can use SqlBulkCopy to save all rows in the DataTable in to the destination table to improve performance (REF).

2] Convert the grid data into csv file and use BULK INSERT SQL Query. (REF)

3] Convert the grid data into xml and follow this

I found a good example here which is similar to your requirement.
Jiteendra Sampathirao15y ago
nice thread....thnx sathish...
Satish Bhat15y ago
You're most welcome.
Morcos Adel15y ago
Thank you Satish for your reply,
it really helped me out..