Here Mudassar Ahmed Khan has explained with an example, how to perform Custom Paging in WebGrid using Stored Procedure and Entity Framework in ASP.Net MVC Razor.

Custom Paging will be performed at Database level inside the Stored Procedure using the ROW_NUMBER function.

The PageIndex and PageSize values will be passed to the Stored Procedure using Entity Framework and only the specific records will be fetched and displayed in WebGrid, thus reducing the bandwidth usage.

Here Mudassar Ahmed Khan has explained with an example, how to perform Select Insert Edit Update and Delete (CRUD) using Single Stored Procedure in ASP.Net MVC Razor.

Single Stored Procedure will be called using Entity Framework and a parameter named Action will be used to send instructions about the operation to be performed in SQL Server database. Single Stored Procedure CRUD operation will be performed by calling the Controller Action methods using jQuery AJAX and JSON in ASP.Net MVC Razor.

Here Mudassar Ahmed Khan has explained with an example, how to implement Client Side AJAX based Paging using jQuery in ASP.Net GridView with C# and VB.Net.

In Client Side Paging, the GridView will not be populated from Server Side instead, a jQuery function will make an AJAX call to the server and fetch the records from database based on Page Index using SQL Server Custom Paging.

Later using jQuery, the fetched records will be used to populate the GridView on Client Side.

Here Mudassar Ahmed Khan has explained with an example, how to perform custom Paging in GridView using jQuery AJAX in ASP.Net with C# and VB.Net.

Custom Paging will be performed within Database using SQL Server Row_Number function and only the records for the requested Page will be sent to the jQuery function using AJAX.

Later using jQuery, the fetched records will be used to populate the GridView on Client Side.