Filter Records in ASP.NET MVC

Question

The following code searches students by students name and it works fine.

I want to add 3 radio button (Enrolled, Not Enrolled, All Students) and filter records based on the radio button selection. How do I do it?

Also, is there a way to put these radio buttons in a group box and some spaces between the buttons?

O Enrolled O Not Enrolled O All Students


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



    

        Search by Student Name:         
 
        @Html.ActionLink("Display Students", "Index")

Accepted Answer

Hi @Hursh, I had a test in my side with an MVC application, here's my codes, could you please help check whether the radio buttons I used solved your issue? In my test, my radio button selected option will be passed to the Controller action. Then we can modify the query clause to query out the required data.

@model WebAppDefIdentity.Models.MovieGenreViewModel
@{
    ViewData["Title"] = "Index";
}
Index

    
        Title: 
       
        Gender:
        
            
                @Html.RadioButtonFor(model => model.Gender, "Male") Male
            
            
                @Html.RadioButtonFor(model => model.Gender, "Female") Female
            
        
        
    


        @foreach (var item in Model.Movies!)
        {
        
}
    
    
        
            
                @Html.DisplayNameFor(model => model.Movies![0].Title)
            
            
                @Html.DisplayNameFor(model => model.Movies![0].ReleaseDate)
            
            
                @Html.DisplayNameFor(model => model.Movies![0].Genre)
            
            
                @Html.DisplayNameFor(model => model.Movies![0].Price)
            
        
    
    
            
                @Html.DisplayFor(modelItem => item.Title)
            
            
                @Html.DisplayFor(modelItem => item.ReleaseDate)
            
            
                @Html.DisplayFor(modelItem => item.Genre)
            
            
                @Html.DisplayFor(modelItem => item.Price)
            
        

public class MovieGenreViewModel
{
    public List? Movies { get; set; }
    public string? SearchString { get; set; }
    public string? Gender { get; set; }
}
public async Task Index(string searchString, string gender)
{
    var movies = from m in _context.Movie
                 select m;
    if (!string.IsNullOrEmpty(searchString))
    {
        movies = movies.Where(s => s.Title!.Contains(searchString));
    }
    var movieGenreVM = new MovieGenreViewModel
    {
        Movies = await movies.ToListAsync()
    };
    return View(movieGenreVM);
}

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,
Tiny

Share via

Filter Records in ASP.NET MVC

0 additional answers