Struggling with DataBinding and persistence

[VBAHole22]

I have an Oracle stored proc that fills a DataTable that I then bind to an ASP.NET 2.0 GridView control. This GridView is in an AJAX.NET update panel and I want it to have paging. It also has a button field. When a user clicks the button it flips a checkbox in the same row. If i page I lose the checked boxes. I want to be able to page, maintain the edits the user is making, and then when they mash a button when they are ready, send the edits myself over to oracle.

 

Can't seem to get it done. If i ditch the paging it's a little easier. As the gridview is being bound I create a dataset in view state. When the use mashes the button I loop over the recs in the gridview and compare the state in the check box with the original for that rec. If there is a difference I act on it.

This system falls apart when you page because you can't compare with row index to find the delta.

I don't mind not having paging but the problem then is that the Ajax.net update progress panel is no longer visible when you scroll down. There is a js script out there to move the div that they progress panel is in but it won't move down past 800px.

 

If I can use a DataTable to bind to a GridView why can I not get the changes back into the DataTable? I should just be notified of the diffs, even with paging.

 

What am I missing?