Ok well I just read something that I never knew before. I had no idea that the Data Adapter was capable of doing data paging all by itself with about half a line of code. Very cool though.
I have no idea how I will be able to access that functionality from within the normal operation of the framework but it's a good place to start.
I do wonder about the performance of it but other than that...

If anyone else is interested in this kind of thing check out these:

Paging with the data adapter - http://www.vbdotnetheaven.com/Code/Sept2003/2173.asp
More info about data paging - http://www.codeproject.com/aspnet/PagingLarge.asp