sqlasp.netsql-serverpagination

Paging design recommendation for asp.net and sqlserver 2005


I am relatively new to programming. My work basically revolves around data and analysis. I want to create a simple asp.net page which shows huge chunk of data from the database. There could be a millions of rows of data which is used for different kinds of analysis/searchin/filtering etc..

Should I write paging logic at the front end or at the back-end (in this case SQL Server 2005)?

What would be the best practice around this? Your suggestions/links to resources in this direction is greatly appreciated.


Solution

  • please use this example Building Custom Paging with LINQ, ListView, DataPager and ObjectDataSource

    Paging of Large Resultsets in ASP.NET ListView and DataPager

    Custom paging in ASP.NET with ListView & DataPager

    Implementing Custom Paging in ASP.NET with SQL Server 2005