How do I do pagination in ASP NET MVC

Question

What is the most preferred and easiest way to do pagination in ASP NET MVC   I e  what is the easiest way to break up a list into several browsable pages   As an example lets say I get a list of elements from a database gateway repository like this   public ActionResult ListMyItems         List lt Item gt  list   ItemDB GetListOfItems        ViewData  ItemList     list       return View        For simplicity s sake I d like to specify just a page number for my action as parameter  Like this   public ActionResult ListMyItems int page

User · Answer

I think the easiest way to create pagination in ASP.NET MVC application is using PagedList library.

There is a complete example in following github repository. Hope it would help.

public class ProductController : Controller
{
    public object Index(int? page)
    {
        var list = ItemDB.GetListOfItems();

        var pageNumber = page ?? 1; 
        var onePageOfItem = list.ToPagedList(pageNumber, 25); // will only contain 25 items max because of the pageSize

        ViewBag.onePageOfItem = onePageOfProducts;
        return View();
    }
}

Demo Link: http://ajaxpagination.azurewebsites.net/

Source Code: https://github.com/ungleng/SimpleAjaxPagedListAndSearchMVC5

User · Answer

I think the easiest way to create pagination in ASP.NET MVC application is using PagedList library.

There is a complete example in following github repository. Hope it would help.

public class ProductController : Controller
{
    public object Index(int? page)
    {
        var list = ItemDB.GetListOfItems();

        var pageNumber = page ?? 1; 
        var onePageOfItem = list.ToPagedList(pageNumber, 25); // will only contain 25 items max because of the pageSize

        ViewBag.onePageOfItem = onePageOfProducts;
        return View();
    }
}

Demo Link: http://ajaxpagination.azurewebsites.net/

Source Code: https://github.com/ungleng/SimpleAjaxPagedListAndSearchMVC5

User · Answer

I had the same problem and found a very elegant solution for a Pager Class from  http   blogs taiga nl martijn 2008 08 27 paging-with-aspnet-mvc   In your controller the call looks like   return View partnerList ToPagedList currentPageIndex  pageSize      and in your view    lt div class  pager  gt      Seite   lt    Html Pager ViewData Model PageSize                             ViewData Model PageNumber                            ViewData Model TotalItemCount   gt   lt  div gt

User · Answer

I had the same problem and found a very elegant solution for a Pager Class from  http   blogs taiga nl martijn 2008 08 27 paging-with-aspnet-mvc   In your controller the call looks like   return View partnerList ToPagedList currentPageIndex  pageSize      and in your view    lt div class  pager  gt      Seite   lt    Html Pager ViewData Model PageSize                             ViewData Model PageNumber                            ViewData Model TotalItemCount   gt   lt  div gt

User · Answer

I wanted to cover a simple way of doing this with the front end too   Controller   public ActionResult Index int page   0        const int PageSize   3     you can always do something more elegant to set this      var count   this dataSource Count         var data   this dataSource Skip page   PageSize  Take PageSize  ToList         this ViewBag MaxPage    count   PageSize  -  count   PageSize    0   1   0        this ViewBag Page   page       return this View data       View      rest of file with view      if  ViewBag Page  gt  0         lt a href   Url Action  Index   new   page   ViewBag Page - 1             class  btn btn-default  gt           amp laquo  Prev      lt  a gt     if  ViewBag Page  lt  ViewBag MaxPage         lt a href   Url Action  Index   new   page   ViewBag Page   1             class  btn btn-default  gt          Next  amp raquo       lt  a gt

User · Answer

I had the same problem and found a very elegant solution for a Pager Class from  http   blogs taiga nl martijn 2008 08 27 paging-with-aspnet-mvc   In your controller the call looks like   return View partnerList ToPagedList currentPageIndex  pageSize      and in your view    lt div class  pager  gt      Seite   lt    Html Pager ViewData Model PageSize                             ViewData Model PageNumber                            ViewData Model TotalItemCount   gt   lt  div gt

User · Answer

Controller     HttpGet      public async Task lt ActionResult gt  Index int page  1                if  page  lt  0    page   0                         page   1                    int pageSize   5          int totalPage   0          int totalRecord   0          BusinessLayer bll   new BusinessLayer            MatchModel matchmodel   new MatchModel            matchmodel GetMatchList   bll GetMatchCore page  pageSize  out totalRecord  out totalPage           ViewBag dbCount   totalPage          return View matchmodel           BusinessLogic     public List lt Match gt  GetMatchCore int page  int pageSize  out int totalRecord  out int totalPage                SignalRDataContext db   new SignalRDataContext            var query   new List lt Match gt             totalRecord   db Matches Count            totalPage    totalRecord   pageSize      totalRecord   pageSize   gt  0   1   0           query   db Matches OrderBy a   gt  a QuestionID  Skip   page - 1    pageSize   Take pageSize  ToList            return query          View for displaying total page count    if  ViewBag dbCount    null                for  int i   1  i  lt   ViewBag dbCount  i                           lt ul class  pagination  gt                   lt li gt  Html ActionLink  i ToString     Index    Grid   new   page    i   null  lt  li gt                lt  ul gt

User · Answer

Entity  public class PageEntity       public int Page   get  set        public string Class   get  set       public class Pagination       public List lt PageEntity gt  Pages   get  set        public int Next   get  set        public int Previous   get  set        public string NextClass   get  set        public string PreviousClass   get  set        public bool Display   get  set        public string Query   get  set        HTML   lt nav gt       lt div class  navigation  style  text-align  center  gt           lt ul class  pagination  gt               lt li class  page-item  Model NextClass  gt  lt a class  page-link  href   page    Model Previous  Model Query   gt  amp laquo  lt  a gt  lt  li gt               foreach  var item in  Model Pages                                 lt li class  page-item  item Class  gt  lt a class  page-link  href   page   item Page  Model Query   gt  item Page lt  a gt  lt  li gt                             lt li class  page-item  Model NextClass  gt  lt a class  page-link  href   page    Model Next  Model Query   gt  amp raquo  lt  a gt  lt  li gt           lt  ul gt       lt  div gt    lt  nav gt    Paging Logic  public Pagination GetCategoryPaging int currentPage  int recordCount  string query        string pageClass   string Empty  int pageSize   10  innerCount   5       Pagination pagination   new Pagination        pagination Pages   new List lt PageEntity gt         pagination Next   currentPage   1      pagination Previous     currentPage - 1   gt  0     currentPage - 1    1      pagination Query   query       int totalPages     int recordCount   pageSize     0    int recordCount   pageSize    int recordCount   pageSize   1       int loopStart   1  loopCount   1       if   currentPage - 2   gt  0                loopStart    currentPage - 2              for  int i   loopStart  i  lt   totalPages  i                  pagination Pages Add new PageEntity   Page   i  Class   string Empty              if  loopCount    innerCount            break             loopCount               if  totalPages  lt   innerCount                pagination PreviousClass    disabled              foreach  var item in pagination Pages Where x   gt  x Page    currentPage                 item Class    active              if  pagination Pages Count    lt   1                pagination Display   false             return pagination      Using Controller  public ActionResult GetPages         int currentPage   1  string search   string Empty      if   string IsNullOrEmpty Request QueryString  page                   currentPage   Convert ToInt32 Request QueryString  page                if   string IsNullOrEmpty Request QueryString  q                   search     amp q     Request QueryString  q                 to be Fetched from database using count        int recordCount   100       Place place   new Place        Pagination pagination   place GetCategoryPaging currentPage  recordCount  search        return PartialView  Controls  Pagination   pagination

User · Answer

Well  what is the data source  Your action could take a few defaulted arguments  i e   ActionResult Search string query  int startIndex  int pageSize          defaulted in the routes setup so that startIndex is 0 and pageSize is  say  20           routes MapRoute  Search    Search  query   startIndex                            new                                                       controller    Home   action    Search                               startIndex   0  pageSize   20                               To split the feed  you can use LINQ quite easily   var page   source Skip startIndex  Take pageSize      or do a multiplication if you use  pageNumber  rather than  startIndex    With LINQ-toSQL  EF  etc - this should  compose  down to the database  too   You should then be able to use action-links to the next page  etc     lt   Html ActionLink  next page    Search   new                   query  startIndex   startIndex   pageSize  pageSize      gt

User · Answer

I wanted to cover a simple way of doing this with the front end too   Controller   public ActionResult Index int page   0        const int PageSize   3     you can always do something more elegant to set this      var count   this dataSource Count         var data   this dataSource Skip page   PageSize  Take PageSize  ToList         this ViewBag MaxPage    count   PageSize  -  count   PageSize    0   1   0        this ViewBag Page   page       return this View data       View      rest of file with view      if  ViewBag Page  gt  0         lt a href   Url Action  Index   new   page   ViewBag Page - 1             class  btn btn-default  gt           amp laquo  Prev      lt  a gt     if  ViewBag Page  lt  ViewBag MaxPage         lt a href   Url Action  Index   new   page   ViewBag Page   1             class  btn btn-default  gt          Next  amp raquo       lt  a gt

User · Answer

Well  what is the data source  Your action could take a few defaulted arguments  i e   ActionResult Search string query  int startIndex  int pageSize          defaulted in the routes setup so that startIndex is 0 and pageSize is  say  20           routes MapRoute  Search    Search  query   startIndex                            new                                                       controller    Home   action    Search                               startIndex   0  pageSize   20                               To split the feed  you can use LINQ quite easily   var page   source Skip startIndex  Take pageSize      or do a multiplication if you use  pageNumber  rather than  startIndex    With LINQ-toSQL  EF  etc - this should  compose  down to the database  too   You should then be able to use action-links to the next page  etc     lt   Html ActionLink  next page    Search   new                   query  startIndex   startIndex   pageSize  pageSize      gt

User · Answer

Well  what is the data source  Your action could take a few defaulted arguments  i e   ActionResult Search string query  int startIndex  int pageSize          defaulted in the routes setup so that startIndex is 0 and pageSize is  say  20           routes MapRoute  Search    Search  query   startIndex                            new                                                       controller    Home   action    Search                               startIndex   0  pageSize   20                               To split the feed  you can use LINQ quite easily   var page   source Skip startIndex  Take pageSize      or do a multiplication if you use  pageNumber  rather than  startIndex    With LINQ-toSQL  EF  etc - this should  compose  down to the database  too   You should then be able to use action-links to the next page  etc     lt   Html ActionLink  next page    Search   new                   query  startIndex   startIndex   pageSize  pageSize      gt

User · Answer

I had the same problem and found a very elegant solution for a Pager Class from  http   blogs taiga nl martijn 2008 08 27 paging-with-aspnet-mvc   In your controller the call looks like   return View partnerList ToPagedList currentPageIndex  pageSize      and in your view    lt div class  pager  gt      Seite   lt    Html Pager ViewData Model PageSize                             ViewData Model PageNumber                            ViewData Model TotalItemCount   gt   lt  div gt

User · Answer

Well  what is the data source  Your action could take a few defaulted arguments  i e   ActionResult Search string query  int startIndex  int pageSize          defaulted in the routes setup so that startIndex is 0 and pageSize is  say  20           routes MapRoute  Search    Search  query   startIndex                            new                                                       controller    Home   action    Search                               startIndex   0  pageSize   20                               To split the feed  you can use LINQ quite easily   var page   source Skip startIndex  Take pageSize      or do a multiplication if you use  pageNumber  rather than  startIndex    With LINQ-toSQL  EF  etc - this should  compose  down to the database  too   You should then be able to use action-links to the next page  etc     lt   Html ActionLink  next page    Search   new                   query  startIndex   startIndex   pageSize  pageSize      gt

User · Answer

Entity  public class PageEntity       public int Page   get  set        public string Class   get  set       public class Pagination       public List lt PageEntity gt  Pages   get  set        public int Next   get  set        public int Previous   get  set        public string NextClass   get  set        public string PreviousClass   get  set        public bool Display   get  set        public string Query   get  set        HTML   lt nav gt       lt div class  navigation  style  text-align  center  gt           lt ul class  pagination  gt               lt li class  page-item  Model NextClass  gt  lt a class  page-link  href   page    Model Previous  Model Query   gt  amp laquo  lt  a gt  lt  li gt               foreach  var item in  Model Pages                                 lt li class  page-item  item Class  gt  lt a class  page-link  href   page   item Page  Model Query   gt  item Page lt  a gt  lt  li gt                             lt li class  page-item  Model NextClass  gt  lt a class  page-link  href   page    Model Next  Model Query   gt  amp raquo  lt  a gt  lt  li gt           lt  ul gt       lt  div gt    lt  nav gt    Paging Logic  public Pagination GetCategoryPaging int currentPage  int recordCount  string query        string pageClass   string Empty  int pageSize   10  innerCount   5       Pagination pagination   new Pagination        pagination Pages   new List lt PageEntity gt         pagination Next   currentPage   1      pagination Previous     currentPage - 1   gt  0     currentPage - 1    1      pagination Query   query       int totalPages     int recordCount   pageSize     0    int recordCount   pageSize    int recordCount   pageSize   1       int loopStart   1  loopCount   1       if   currentPage - 2   gt  0                loopStart    currentPage - 2              for  int i   loopStart  i  lt   totalPages  i                  pagination Pages Add new PageEntity   Page   i  Class   string Empty              if  loopCount    innerCount            break             loopCount               if  totalPages  lt   innerCount                pagination PreviousClass    disabled              foreach  var item in pagination Pages Where x   gt  x Page    currentPage                 item Class    active              if  pagination Pages Count    lt   1                pagination Display   false             return pagination      Using Controller  public ActionResult GetPages         int currentPage   1  string search   string Empty      if   string IsNullOrEmpty Request QueryString  page                   currentPage   Convert ToInt32 Request QueryString  page                if   string IsNullOrEmpty Request QueryString  q                   search     amp q     Request QueryString  q                 to be Fetched from database using count        int recordCount   100       Place place   new Place        Pagination pagination   place GetCategoryPaging currentPage  recordCount  search        return PartialView  Controls  Pagination   pagination

User · Answer

public ActionResult Paging int  pageno bool  fwd bool  bwd                if pageno  null                Session  currentpage     pageno              using  HatronEntities DB   new HatronEntities                  if fwd  null  amp  amp   bool fwd                        pageno   Convert ToInt32 Session  currentpage      1              Session  currentpage     pageno                    if  bwd    null  amp  amp   bool bwd                        pageno   Convert ToInt32 Session  currentpage    - 1              Session  currentpage     pageno                    if  pageno  null                        pageno   1                    if pageno lt 0                        pageno   1                    int total   DB EmployeePromotion 0  0  0  Count            int  totalPage    int Math Ceiling  double total   20           ViewBag pages   totalPage          if  pageno  gt  totalPage                        pageno   totalPage                    return View  DB EmployeePromotion 0 0 0  Skip GetSkip  int pageno 20   Take 20  ToList                   private static int GetSkip int pageIndex  int take        return  pageIndex - 1    take      model IEnumerable lt EmployeePromotion Result gt       Layout   null       lt  DOCTYPE html gt     lt html gt    lt head gt       lt meta name  viewport  content  width device-width    gt       lt title gt Paging lt  title gt     lt  head gt     lt body gt    lt div gt        lt table border  1  gt           foreach  var itm in Model              lt tr gt      lt td gt  itm District lt  td gt      lt td gt  itm employee lt  td gt      lt td gt  itm PromotionTo lt  td gt    lt  tr gt                 lt  table gt       lt a href   Url Action  Paging    Home  new   pageno 1     gt First  page lt  a gt        lt a href   Url Action  Paging    Home   new   bwd  true     gt  lt  lt  lt  a gt        for int itmp  1  itmp lt  Convert ToInt32 ViewBag pages  1 itmp                 lt a href   Url Action  Paging    Home  new   pageno itmp       gt  itmp ToString   lt  a gt            lt a href   Url Action  Paging    Home   new   fwd   true     gt  gt  gt  lt  a gt        lt a href   Url Action  Paging    Home   new   pageno                                                                                 Convert ToInt32 ViewBag pages      gt Last page lt  a gt    lt  div gt      lt  body gt     lt  html gt

User · Answer

Here s a link that helped me with this   It uses PagedList MVC NuGet package  I ll try to summarize the steps   Install the PagedList MVC NuGet package Build project  Add using PagedList  to the controller Modify your action to set page  public ActionResult ListMyItems int  page       List list   ItemDB GetListOfItems       int pageSize   3     int pageNumber    page    1      return View list ToPagedList pageNumber  pageSize       Add paging links to the bottom of your view    Your existing view   Page   Model PageCount  lt  Model PageNumber   0   Model PageNumber  of  Model PageCount  Html PagedListPager Model  page    Url Action  Index        new   page  sortOrder   ViewBag CurrentSort  currentFilter   ViewBag CurrentFilter

User · Answer

Here s a link that helped me with this   It uses PagedList MVC NuGet package  I ll try to summarize the steps   Install the PagedList MVC NuGet package Build project  Add using PagedList  to the controller Modify your action to set page  public ActionResult ListMyItems int  page       List list   ItemDB GetListOfItems       int pageSize   3     int pageNumber    page    1      return View list ToPagedList pageNumber  pageSize       Add paging links to the bottom of your view    Your existing view   Page   Model PageCount  lt  Model PageNumber   0   Model PageNumber  of  Model PageCount  Html PagedListPager Model  page    Url Action  Index        new   page  sortOrder   ViewBag CurrentSort  currentFilter   ViewBag CurrentFilter

User · Answer

Controller     HttpGet      public async Task lt ActionResult gt  Index int page  1                if  page  lt  0    page   0                         page   1                    int pageSize   5          int totalPage   0          int totalRecord   0          BusinessLayer bll   new BusinessLayer            MatchModel matchmodel   new MatchModel            matchmodel GetMatchList   bll GetMatchCore page  pageSize  out totalRecord  out totalPage           ViewBag dbCount   totalPage          return View matchmodel           BusinessLogic     public List lt Match gt  GetMatchCore int page  int pageSize  out int totalRecord  out int totalPage                SignalRDataContext db   new SignalRDataContext            var query   new List lt Match gt             totalRecord   db Matches Count            totalPage    totalRecord   pageSize      totalRecord   pageSize   gt  0   1   0           query   db Matches OrderBy a   gt  a QuestionID  Skip   page - 1    pageSize   Take pageSize  ToList            return query          View for displaying total page count    if  ViewBag dbCount    null                for  int i   1  i  lt   ViewBag dbCount  i                           lt ul class  pagination  gt                   lt li gt  Html ActionLink  i ToString     Index    Grid   new   page    i   null  lt  li gt                lt  ul gt

User · Answer

public ActionResult Paging int  pageno bool  fwd bool  bwd                if pageno  null                Session  currentpage     pageno              using  HatronEntities DB   new HatronEntities                  if fwd  null  amp  amp   bool fwd                        pageno   Convert ToInt32 Session  currentpage      1              Session  currentpage     pageno                    if  bwd    null  amp  amp   bool bwd                        pageno   Convert ToInt32 Session  currentpage    - 1              Session  currentpage     pageno                    if  pageno  null                        pageno   1                    if pageno lt 0                        pageno   1                    int total   DB EmployeePromotion 0  0  0  Count            int  totalPage    int Math Ceiling  double total   20           ViewBag pages   totalPage          if  pageno  gt  totalPage                        pageno   totalPage                    return View  DB EmployeePromotion 0 0 0  Skip GetSkip  int pageno 20   Take 20  ToList                   private static int GetSkip int pageIndex  int take        return  pageIndex - 1    take      model IEnumerable lt EmployeePromotion Result gt       Layout   null       lt  DOCTYPE html gt     lt html gt    lt head gt       lt meta name  viewport  content  width device-width    gt       lt title gt Paging lt  title gt     lt  head gt     lt body gt    lt div gt        lt table border  1  gt           foreach  var itm in Model              lt tr gt      lt td gt  itm District lt  td gt      lt td gt  itm employee lt  td gt      lt td gt  itm PromotionTo lt  td gt    lt  tr gt                 lt  table gt       lt a href   Url Action  Paging    Home  new   pageno 1     gt First  page lt  a gt        lt a href   Url Action  Paging    Home   new   bwd  true     gt  lt  lt  lt  a gt        for int itmp  1  itmp lt  Convert ToInt32 ViewBag pages  1 itmp                 lt a href   Url Action  Paging    Home  new   pageno itmp       gt  itmp ToString   lt  a gt            lt a href   Url Action  Paging    Home   new   fwd   true     gt  gt  gt  lt  a gt        lt a href   Url Action  Paging    Home   new   pageno                                                                                 Convert ToInt32 ViewBag pages      gt Last page lt  a gt    lt  div gt      lt  body gt     lt  html gt

[c#] How do I do pagination in ASP.NET MVC?

Examples related to c#

Examples related to asp.net

Examples related to asp.net-mvc