Data paging and sorting
I got interested in paging and sorting on large tables. And I found a couple of very good pointers, that I wanted to share with you:
- Manuel Abadia uses the ObjectDataSource to do all that stuff:
ObjectDataSource in Depth (Part 1)
is the first article in a great series of articles explaining the ODS in depth. - Jasmin Muharemovic has dicussed paging of large resultsets.
It is an increadible look into the wonders of SQL and performance. Make sure you check out all of the comments on that article as well. Very informative. - Scott Mitchell wrote another bunch of great articles at 4 guys:
Custom Paging in ASP.NET 2.0 with SQL Server 2005
Sorting Custom Paged Results
This article also features among other things a peek into configuring the ObjectDataSource for sorting with custom paging. - Greg Hamilton has a very interesting optimization using ROWCOUNT.
- Manuel Abadia has another interesting article Custom Paging for TableAdapters without using SPs
- Last but not least there are two articles at ScottGu’s blog:
Paging through lots of data efficiently (and in an Ajax way) with ASP.NET 2.0
Efficient Data Paging with the ASP.NET 2.0 DataList Control and ObjectDataSource
A LOT to read. 
Does anybody have more pointers? I am especially interested in anything related to the ObjectDataSource.
I am in the midst of working on a 30+ tutorial series on working with data in ASP.NET 2.0. All of the examples use a tiered architecture with a DAL built up from Typed DataSets, a custom BLL, and use of the ObjectDataSource in the ASP.NET presentation layer.
It’s not yet on MSDN or http://www.asp.net... once it is, though, I’ll be sure to publicize it shamelessly on both my blog and on 4GuysFromRolla.com
Thanks
Comment on May 19, 2006 @ 23:45:55
Hi Scott,
thanks for your comment. I would be honored, if you came back and posted a comment as soon as it is finished.
But I guess I will just have to look out for it…
Cheers,
Tobi
Comment on May 20, 2006 @ 01:23:45
thanks alot for your info
Comment on June 4, 2006 @ 12:42:07
With many requests and urging from Scott Mitchell, I will follow-up on my paging article on 4GuysFromRolla.com in the near future to incorporate sorting in the paging routines. Once complete, I will try to get back here and post a comment on it.
Greg
Comment on July 17, 2006 @ 18:38:25
Hey Greg,
thanks for dropping by. I am really looking forward to a new instalment of yours. Please feel free to post a pointer here. I would love to read it!
Thanks,
Tobi
Comment on July 17, 2006 @ 21:09:57