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 attach Double Click event handler to WebGrid Row using jQuery in ASP.Net MVC Razor.

A Client Side Double Click event handler will be attached to the WebGrid row using jQuery and thus when the WebGrid row is double clicked, the data from the selected WebGrid row will be fetched using jQuery and will be posted in JSON format to the Controller’s Action method using Form Submission in ASP.Net MVC Razor.

Here Mudassar Ahmed Khan has explained with an example, how to load data on demand on scroll in WebGrid using jQuery AJAX in ASP.Net MVC Razor.

The WebGrid has Fixed (Freezed) Header Row and the Data Rows have a Scrollbar and when the Scrollbar is scrolled, an AJAX call is made to the Controller’s Action method and the data is loaded in WebGrid.

The records from Database are loaded in WebGrid Page Wise as the data is scrolled using jQuery AJAX, JSON and Entity Framework in ASP.Net MVC Razor.