Server Side Paging with data from multiple tables in ASP.Net MVC

Question

1 Category Master with CRUD operations2 Product Master with CRUD operations A product belongs to a category3 Product list should be displayed with following Columns ProductId ProductName CategoryId CategoryName4 The product list should have pagination on the server side which means extract records from DB as per the page size on the viewSo if the page size is 10 and the user is on page 9 then pull only records from 90  100

dharmendr · Accepted Answer

ReferMVC ADONet CRUD Select Insert Edit Update and Delete using ADONet in ASPNet MVC RazorServer Side Paging using Entity Framework in ASPNet MVC

PrinceG · Answer

Hi azishan91Please refer below sampleDatabaseFor this example I have used of Northwind database that you can download using the link given belowDownload Northwind DatabaseModelpublic class CustomerModel    public ListltDatagt Datas  get set     public int CurrentPageIndex  get set     public int PageCount  get set public class Data    public string CustomerId  get set     public string Name  get set     public int OrderId  get set     public string ShipName  get set Controller public ActionResult Index    return ViewthisGetCustomers1HttpPostpublic ActionResult Indexint currentPageIndex    return ViewthisGetCustomerscurrentPageIndexprivate CustomerModel GetCustomersint currentPage    int maxRows  10    using NORTHWINDEntities entities  new NORTHWINDEntities            CustomerModel customerModel  new CustomerModel        customerModelDatas  from customer in entitiesCustomers                                jo

Server Side Paging with data from multiple tables in ASP.Net MVC

MVC ADO.Net CRUD: Select Insert Edit Update and Delete using ADO.Net in ASP.Net MVC Razor

Server Side Paging using Entity Framework in ASP.Net MVC

Company

Explore

Follow us

Contact Us