Please help!! Updating several rows of data in a gridview

Hi,
I have a gridview with text boxes (description fields) and dropdown lists along with bound fields. I am using an ObjectDataSource. I am able to easily populate the relavant fields based on my ObjectDataSource. I have a need to be able to permit users to edit the text boxes and change the values in the dropdown list and save all the changes to all rows to the database. I am not using GridView's inbuilt select / update / insert functions in other words, I dont want to save changes per record, instead want to be able to save changes once when the user clicks on a save button.

One thought I had was to create a collection of objects for each row, but that would be an expensive operation with performance issues (if the list is long).

I was wondering if anyone else had faced this issue and how you solved it.

Any help is appreciated.

Regards
Jay

I had this situation and my project required only this approach of saving data from all the pages. I've not tried with gridview (2.0), but I worked with datagrid(1.1). I guess you can still do in gridview what I did with datagrid. I found an aticle in MSDN and just followed that (and that works pretty good). All it does is loop through all the rows and fetch required control's info and save data one by one. If you don;t like this, an alternate would be to gather all data into an xml and process the xml in backend DB (stored procedures. I believe it's MSSql Server) to store data in one go.

Let me know if you can't find that in MSDN or first what's your idea with collection of controls. May be your approach is the same as that.