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

Answer 1

Hi...

Even I have been developing Games in C++ and in C#.NET...

I am interested if your project is all about making games!!!!!

My Email ID - [e-mail]

Do send me the details/requirements so that I can start working on it ....

Thanks !!