Bulk update with a stored procedure ?

Question

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

Satish Bhat · 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 Sampathirao · Answer

nice thread....thnx sathish...

Satish Bhat · Answer

You're most welcome.

Morcos Adel · Answer

Thank you Satish for your reply it really helped me out..