Paging Issue in asp.net MVC

Question

I am trying to add paging but get the error: CS1061: 'IEnumerable' does not contain a definition for 'PageCount' and no accessible extension method 'PageCount' accepting a first argument of type 'IEnumerable' could be found (are you missing a using directive or an assembly reference?)

I've tried with PagedList.Mvc NuGet package (Install-Package PagedList.Mvc) but it did not fix the issue. I then tried the X.PageList but it was not able to install. The code below is from

Index.cshtml

@model PagedList.IPagedList
@using PagedList.Mvc;

@{
ViewBag.Title = "Students";
}
Students

@Html.ActionLink("Create New", "Create")

@using (Html.BeginForm("Index", "Student", FormMethod.Get))
{

    Find by name: @Html.TextBox("SearchString", ViewBag.CurrentFilter as string)
    

}

@foreach (var item in Model) {

}


    
        @Html.DisplayNameFor(model => model.StudentID)
    
    
        @Html.DisplayNameFor(model => model.FirstName)
    
    
        @Html.ActionLink("Last Name", "Index", new { sortOrder = ViewBag.NameSortParm })
    
    
    

    
        @Html.DisplayFor(modelItem => item.LastName)
    
    
        @Html.DisplayFor(modelItem => item.FirstMidName)
    
    
        @Html.DisplayFor(modelItem => item.EnrollmentDate)
    



Page @(Model.PageCount < Model.PageNumber ? 0 : Model.PageNumber) of @Model.PageCount
@Html.PagedListPager(Model, page => Url.Action("Index", new { page, sortOrder = ViewBag.CurrentSort, currentFilter = ViewBag.CurrentFilter }))

StudentController.cs

public ViewResult Index(string sortOrder, string searchString)
{

ViewBag.NameSortParm = String.IsNullOrEmpty(sortOrder) ? "name_desc" : "";

ViewBag.DateSortParm = sortOrder == "Date" ? "date_desc" : "Date";

var students = from s in db.Students

               select s;

if (!String.IsNullOrEmpty(searchString))

{

    students = students.Where(s => s.LastName.Contains(searchString)

                           || s.FirstMidName.Contains(searchString));

}

switch (sortOrder)

{

    case "name_desc":

        students = students.OrderByDescending(s => s.LastName);

        break;

    case "Date":

        students = students.OrderBy(s => s.EnrollmentDate);

        break;

    case "date_desc":

        students = students.OrderByDescending(s => s.EnrollmentDate);

        break;

    default:

        students = students.OrderBy(s => s.LastName);

        break;

}

return View(students.ToList());
}

Accepted Answer

Hi @Malam Malam

Your shared code seems contain multiple issues, any way i shared a whole working demo about how to use X.PagedList to paging the data.

Be sure download X.PagedList and X.PagedList.Mvcpackage. Check the packages.config file the package name and version should be like below:

Model

public class Student
{
    public int StudentID { get; set; }
    public string FirstName { get; set; }
    public string FirstMidName { get; set; }
    public DateTime EnrollmentDate { get; set; }
    public string LastName { get; set; }
}

Index.cshtml

@model X.PagedList.IPagedList
@using X.PagedList.Mvc; @*import this so we get the HTML Helper*@
@{
    ViewBag.Title = "Students";
}
Students

    @Html.ActionLink("Create New", "Create")

@using (Html.BeginForm("Index", "Student", FormMethod.Get))
{
    
        Find by name: @Html.TextBox("SearchString", ViewBag.CurrentFilter as string)
        
    
}

    @foreach (var item in Model)
    {
        
    }

    
        
            @Html.ActionLink("LastName", "Index", new { sortOrder = ViewBag.NameSortParm })
        
        
            FirstMidName
        
        
            @Html.ActionLink("EnrollmentDate", "Index", new { sortOrder = ViewBag.DateSortParm })
        
        
    

            
                @Html.DisplayFor(modelItem => item.LastName)
            
            
                @Html.DisplayFor(modelItem => item.FirstMidName)
            
            
                @Html.DisplayFor(modelItem => item.EnrollmentDate)
            
        


Page @(Model.PageCount < Model.PageNumber ? 0 : Model.PageNumber) of @Model.PageCount
@Html.PagedListPager(Model, page => Url.Action("Index", new { page, sortOrder = ViewBag.CurrentSort, currentFilter = ViewBag.CurrentFilter }))

Controller


public ViewResult Index(string sortOrder, string searchString,int page=1)
{
    ViewBag.NameSortParm = String.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
    ViewBag.DateSortParm = sortOrder == "Date" ? "date_desc" : "Date";
    var students = from s in db.Students
                    select s;
    if (!String.IsNullOrEmpty(searchString))
    {
        students = students.Where(s => s.LastName.Contains(searchString)
                                || s.FirstMidName.Contains(searchString));
    }
    switch (sortOrder)
    {
        case "name_desc":
            students = students.OrderByDescending(s => s.LastName);
            break;
        case "Date":
            students = students.OrderBy(s => s.EnrollmentDate);
            break;
        case "date_desc":
            students = students.OrderByDescending(s => s.EnrollmentDate);
            break;
        default:
            students = students.OrderBy(s => s.LastName);
            break;
    }
    //define the size of each page
    const int pageSize = 5;
    var listPaged = students.ToPagedList(page, pageSize); //convert to IPagedList
    return View(listPaged);
}

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Best regards,
Rena

Answer

I suggest that you write pager accoding to the following Microsoft tutorial:

Tutorial: Add sorting, filtering, and paging - ASP.NET MVC with EF Core

See Add paging to Students Index section in the above tutorial which shows the source code of PaginatedList class. Consider using PaginatedList class so that you will be able to write your pager code all under your control rather than using NuGet packages for paging.

Share via

Paging Issue in asp.net MVC

1 additional answer