forum

home / developersection / forums / how to sorting with the entity framework is an asp.net mvc application

Ask Question

How to sorting with the entity framework is an ASP.NET MVC Application

Anupam Mishra 1605 05-Feb-2016
Hello Everyone,
I want to know how to sort record with the using of entity framework in ASP.NET MVC. Can anyone give me a solution with example.

Thank you.
asp.net c#  asp.net  asp.net mvc 
Updated on 05-Feb-2016
Anupam Mishra

Other

Follow Message
Can you answer this question?
Answer

1 Answers

Anupam Mishra

Anupam Mishra

05-Feb-2016
Finally, I have solve this problem.
For solution of above problem, we are creating  one student controller and its index view. We want to display  a sort records(i.e. First Name,Last Name or Enrollment date) in index view.
this is a code of Student Controller Index Action:
public ActionResult Index(string sortOrder)
{
   ViewBag.NameSortParm = String.IsNullOrEmpty(sortOrder) ? "Name" : "";
   ViewBag.DateSortParm = sortOrder == "Date" ? "Date_desc" : "Date";
   var students = from s in db.Student  // Student is a table i.e. containing records of student
                  select s;
   switch (sortOrder)
   {
      case "Name":
         students = students.OrderByDescending(s => s.FirstName);
         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.FirstName);
         break;
   }
   return View(students.ToList());
}

In Views\Student\Index.cshtml, We have changed below lines:

<p>
    @Html.ActionLink("Create New Student Record", "Create")
</p>
<table>
    <tr>
        <th>
            @Html.ActionLink("First Name", "Index", new { sortOrder = ViewBag.NameSortParm })
        </th>
        <th> Last Name
        </th>
        <th>
            @Html.ActionLink("Enrollment Date", "Index", new { sortOrder = ViewBag.DateSortParm })
        </th>
        <th></th>
    </tr>

    @foreach (var item in Model)
    {
advertising
advertising

Liked By

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy