I'm in the middle of this book (or, more precisely, "Beginning ASP.NET Databases Using VB.NET") and have a question about the DataGrid Paging example in Chapter 5. Since my head is bloody from hitting it against a brick wall (and the wall doesn't look too good either:D) I thought I'd post it (the question, not my head) here.

Why is it necessary, in the GridPageChanged handler (which is called when the user pages) to repeat the call to DataFiller() and thus requery the source and refill the DataSet (I don't know whether the connection and adapter objects are recreated or not)? Shouldn't just a DataBind() work? I mean, the DataSet contains all the records anyway. If you're going to keep requerying how about doing your own calculations and just pulling down the appropriate page of data?

I am assuming my naivete is showing and there is a very good reason for this. It's just that I'm curious.

Thanks for any info.

=NLK=

This is almost a year since you wrote.
I mirror your sentiments...but did you get an answer?
You probably know more than I at this point.

Am working through Beginning Dynamic Websites and also the ASP.NET for Databases books. What fun.
I'm convinced noone totally tests these as a new and dumb user without any setup! ha