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

Question

Anupam Mishra · Answer

Finally, I have resolve this problem.For Solution of above problem, we are creatingand  one student controller and its index view. We want to display and a Filter records(i.e. First Name,Last Name ) in index view. For this we create a search string text box in a view forand searchingand and FirstName,LastName in student records.this is a code of Student controller Index Action:public ActionResult Index(string sortOrder, string searchString, string currentFilter){ViewBag.NameSortParm = String.IsNullOrEmpty(sortOrder) ? "Name" : "";ViewBag.DateSortParm = sortOrder == "Date" ? "Date_desc" : "Date";ViewBag.CurrentFilter = searchString;if (!String.IsNullOrEmpty(searchString))
    {
        students = students.Where(s =andgt; s.FirstName.ToUpper().Contains(searchString.ToUpper())
                               || s.LastName.ToUpper().Contains(searchString.ToUpper()));
    }{        students = students.Where(s =andgt; s.FirstName.ToUpper().Contains(searchString.ToUpper())|| s.LastName.ToUpper().Contains(searchString.ToUpper()));}
   var students = from s in db.Student  // Student is a table i.e. containing records of studentselect s;switch (sortOrder){case "Name":         students = students.OrderByDescending(s =andgt; s.FirstName);break;case "Date":         students = students.OrderBy(s =andgt; s.EnrollmentDate);break;case "Date_desc":         students = students.OrderByDescending(s =andgt; s.EnrollmentDate);break;default:         students = students.OrderBy(s =andgt; s.FirstName);break;}return View(students.ToList());}Now. we have changed the index view of student. Code is as Follows:and   andlt;h2andgt;Student Indexandlt;/h2andgt;
    andlt;pandgt;
    @Html.ActionLink("Create New",  "Create")
    @using (Html.BeginForm("Index", "Student", FormMethod.Get))
     {
    andlt;pandgt;
        Find by name: @Html.TextBox("SearchString", ViewBag.CurrentFilter as string)  
        andlt;input type="submit" value="Search" /andgt;

forum

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

Anupam Mishra

Can you answer this question?

1 Answers

Liked By