SQL Queries For Paging In ASP.NET
This tutorial explains different ways about how to build SQL queries for paging on SQL Server. Data paging is common task for ASP.NET developers. It could be very confusing if you place hundreds, thousands or even millions of records on single page. Common solution when you work with large amount of data is to provide data paging.