http://www.codeproject.com/cs/database/row_number.asp
Using ROW_NUMBER() to paginate your data with SQL Server 2005 and ASP.NET
By Jason Witty
With the release of SQL Server 2005, Microsoft introduces the long overdue ROW_NUMBER() function. In this article, we will walk through a C# implementation of pagination using the ROW_NUMBER() method.