Morcos Adel

Morcos Adel

  • NA
  • 195
  • 50.2k

Bulk update with a stored procedure ?

Aug 17 2011 7:38 AM
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

Answers (4)