I'm just wondering if anyone has any input on what the best practice would be for data paging within the framework. In my case it's for a windows forms application. I'm also dealing with over 100 million records in several tables so it's rather important. I've read an interesting article relating to ADO.Net data paging located at:
http://www.codeproject.com/aspnet/PagingLarge.asp

Unfortunately none of the paging methods described in that article are all that elegant. As a matter of fact I believe the most performant one as described by the author has a serious flaw in that it uses ROWCOUNT. I believe using ROWCOUNT in this manner has serious server wide implications. I know it doesn't stay within a given scope well although I don't know if it effects the entire server or just a given user etc. Anyways I thought I would get the opinion of this audience as to the best general method for use with the MM.Net framework or perhaps an alternative method.

Any insight would be greatly appreciated.

By the way... I'm moving this thread from the ADO.Net category to here as I feel it's a bit more appropriate. Please excuse the mistake as I'm new to this forum and it takes some getting used to. Unfortunately I have no way to delete the other message but perhaps that's just as well. It really applies to both after all. It also gives me the opportunity to elaborate a bit.