14 thoughts on “Paging Made Easy with ASP.NET MVC 5, Entity Framework 6 and PageList.Mvc”

1. Hi there,
   I am currently testing the paging extended modification suggested in your web post. However, I encountered a problem whereby the pagesize value were not set, ie always to default. Specifically, in the view:

   @Html.PagedListPager(Model, page => Url.Action(ActionNames.Index,
   new { page, itemsPerPage = ViewBag.CurrentItemsPerPage }));

   the itemsPerpage returned to the controller is always null no matter what value is selected in the dropdownlist.
   If I were to set the ViewBag.CurrentItemsPerPage in the controller to a value, then this hardcoded value persists throughout; but this is not what we want.

   Your help is very much appreciated.

   Thanks.

   1. Liu,

      I did some testing and found one scenario where the selected number of items (itemsPerPage) is not passed to the controller.

      In my tests this happened when the DropDownList used to select the number of items is not located inside the scope of @using (Html.BeginForm(...) in the view.

      Hth,

      Stefan

2. Hi Stefan,
   Thx.
   Best Rgds,
   Liu

   1. You’re welcome 🙂

      Stefan

3. Thanks my friend! What I did is the following:
   // in Controller
   public ViewResult Index(int? page = null, int? pageSize = null)
   {
   ViewBag.CurrentItemsPerPage = pageSize ?? 10; // default 10
   // … do all to get list
   return View(list.ToPagedList(page ?? 1, pageSize ?? 10);
   }

   // in View. As is Index action I didn´t have a beginForm I added it just for pageSize
   @using (Html.BeginForm(“Index”, “ControllerName”, FormMethod.Post))
   {
   @Html.DropDownList(“pageSize”, DefaultValues.ItemsPerPageList, new { @id = “pageSize”, onchange=”this.form.submit();” })
   }

   // At the bottom when PagedList paginates I added the pageSize
   @Html.PagedListPager(Model, page => Url.Action(“Index”, new { page, pageSize = ViewBag.CurrentItemsPerPage }))

   The paging will be done with default 10 records per page. When you change the items per page in the dropdown list, a submit will be done to show the selected items per page value. Then the paging will be performed remembering the chosen value.

   Hope it helps! 😀

4. Would someone be willing to link to the view code they have that’s working?

   I’m trying to figure out where to put the DefaultValues class.

   I’ve tried putting the in C# (next to the controller code), putting it in the view in various places… (above, below, inside “@using (Html.BeginForm(…”, outside it… no matter where I put it, I get the error (when I run the page):

   The name ‘DefaultValues’ does not exist in the current context

   from this line:

   @Html.DropDownList(“ItemsPerPage”, DefaultValues.ItemsPerPageList, new { @id = “ItemsPerPageList”, onchange=”this.form.submit();” })

   So… where does it go!?

   [in the view, when it wasn’t seeming to be treated as static text (i.e. it had syntax highlighting), then the compiler said “List” wasn’t a valid value — it was expecting something like “List” or something like that… but even when I added that, it still doesn’t work.

   1. Put the DefaultValues class into its own .cs file. Do not try to put it into .cshtml files.

      Hth,

      Stefan

5. Excellent article.
   Can we have a complete code with all the changes you have specified above that would be really helpful.

   Thanks,

   1. Fenil,

      I’m sorry but I haven’t put the changes together. In case you are going to do so and publish it in your blog, please let me know. I will add a link to it then.

      Thanks,

      Stefan

6. Hello ! Thanks for this! But i have a problem :

   this is my controller
   …..
   // Pour pagination
   SelectList itemsPerPageList = DefaultValues.ItemsPerPageList;
   itemsPerPage = (int)itemsPerPageList.SelectedValue;
   ViewBag.CurrentItemsPerPage = itemsPerPage;
   int pageNumber = (page ?? 1);
   …..
   return View(“ResultatView”, ListeResultatViewModel.ToPagedList(pageNumber, itemsPerPage ?? 10));

   This my DefaultValues class :
   public static class DefaultValues
   {
   public static SelectList ItemsPerPageList
   {
   get
   {
   return (new SelectList(new [] {10, 25, 50, 100 },
   selectedValue: 10));
   }
   }
   }

   And finally my view :

   in My BeginForm(..)
   if (Model != null)
   {

   @Html.DropDownList(“ItemsPerPage”,DefaultValues.ItemsPerPageList, new { @id = “ItemsPerPageList” })

   }

   and out :

   @Html.PagedListPager(Model, page => Url.Action(“ResultatView”, new { page, sortOrder = ViewBag.CurrentSort, itemsPerPage = ViewBag.CurrentItemsPerPage }))

   @if (Model != null && Model.PageCount > 0)
   {

   Page @(Model.PageCount < Model.PageNumber ? 0 : Model.PageNumber) sur @Model.PageCount (@(Model.TotalItemCount))

   }

   When i change the value in my dropdown, nothing happens

   have some ideas ?

   Thanks

7. Where does the –

   public static class DefaultValues
   {
   …
   public static SelectList ItemsPerPageList
   {
   get
   { return (new SelectList(new List { 5, 10, 25, 50, 100 },
   selectedValue: 10));
   }
   }
   …
   }

   go?

   1. This is a new class which should go into its own file. It is used by the view.

      Hope this answers your question. If not, please give more details.

      Regards,

      Stefan

8. On Paging i m getting only 1 when their is 376 pages why
   @Html.PagedListPager(Model, page => Url.Action(“Index”,new { page }))

9. Oh, the deferred execution of Entity Framework ensures the paging is done server side. In fact a call to the database is only made when I do

Comments are closed.