Using ROW_NUMBER() to paginate your data with SQL Server 2005 and ASP.NET

Alternatives

Members may post updates or alternatives to this current article in order to show different approaches or add new features.

No alternatives have been posted.

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

About the Author

Jason Witty

Software Developer (Senior)

United States

Member

For more articles please visit my website:
http://www.aprogrammersjournal.com

A Programmers Journal
RSS

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.

Type	Article
Licence
First Posted	20 Nov 2005
Views	160,615
Bookmarked	81 times

SQL2005IIS6VS2005C#
ASP.NETSQLWindows, +

		9,890,346 members (28,771 online) Visit CodeProject.TV Discuss CodeProject.TV Sign in Email Password Forgot your password? Sign in using