Paging for table data in MVC 3 application with ADO.NET

Question

We are using MVC 3 with ADO.NET. We have to display huge amount of records in screen in a grid. Currently we are using simple html table for the same. We would like to implement paging for the records. All the examples on Net are showing the paging using Entity framework. Any suggestions how to achieve the same using classical ADO.NET? No third party controls.

Answer 1

You may take a look at the following answer which illustrates an efficient way to perform paging directly in SQL Server using plain ADO.NET. You could also take a look at this article. You will of course encapsulate this in a repository method to which you will pass the current page number and the number of records that you wish per page. Then on the UI layer you could use the WebGrid helper which might simplify the task of presenting the data to the user.