AJAX Paging in ASP.NET MVC using JQuery

In this article, we will look into paging using AJAX. We can use this approach to load few rows on page load and remaining on demand. Here, we will look into html table paging. I am going to explain it with a sample MVC application. Create an ASP.NET MVC 2 web application and name it as JQueryPaging. We no need to add JQuery script files manually, since MVC have built-in support for JQuery. We are not going to use any JQuery plug-ins in this sample. In this sample, we will create an html table and load rows into it on demand like clicking on next, previous links.

I added few images to content folder to show first, next page links. Now, create a SQL Server Database with a table called "Employees" under app_data folder. Create a LINQ to SQL class component [EmpDC.dbml] and drop Employees table onto it from Server Explorer. Add the below code to index view under Home controller: