Wednesday, February 15, 2006

Paging through lots of data with MS SQL Server 2005 and ASP.NET 2.0

This link explains how MS SQL Server 2005 supports paging in GridView (web control in ASP.NET 2.0) through "ROW_NUMBER() OVER (...)" function:

Paging through lots of data efficiently with ASP.NET 2.0

This is another article on the "SQL Pager" topic:
Returning Ranked Results with Microsoft SQL Server 2005
You can find here some nice stuff about Ranking SELECT's resultset.

No comments:

Followers

About Me

My photo
Email me: blog@postjobfree.com