Hello AllSelecting the CheckBoxes on Page LoadI have the following two Model classesPublic partial class EmployeeInfo public int EmployeeInfoId get set public virtual ListltReassignmentSectiongt ReassignmentSections get set new ListltReassignmentSectiongtpublic class ReassignmentSection public int ReassignmentSectionId get set public int EmployeeInfoId get set public int ReassignmentSectionLookupId get set NotMapped publi

Set CheckBox checked (selected) on page load from Database in ASP.Net Core Razor Pages

anjali60...

SOLVED CLOSED ACTIVE ANSWERED
User: anjali600
Posted: on Feb 16, 2023 11:19 PM
Forum: ASP.Net Core Razor Pages
Answer: 1
Views: 8303

Hello All,

Selecting the CheckBoxes on Page Load

I have the following two Model classes:

Public partial class EmployeeInfo
{
    
    public int EmployeeInfoId { get; set; }
    public virtual List<ReassignmentSection> ReassignmentSections { get; set; } = new List<ReassignmentSection>();
}
public class ReassignmentSection
{
    public int ReassignmentSectionId { get; set; }
    public int EmployeeInfoId { get; set; }
    public int ReassignmentSectionLookupId { get; set; }
    [NotMapped]
    public string[] SelectedSection { get; set; }
    public virtual EmployeeInfo EmployeeInfo { get; set; } = null!;
}

I have the following code on my controller:

ViewData["ITSections"] = ITSections.Select(x => new SelectListItem
{
    Value = x.ReassignmentSectionLookupId.ToString(),
    Text = x.Section
}).ToList();

On my razor page, I am binding the checkbox list like this:

@{
    var ITSections = ViewData["ITSections"] as List<SelectListItem>;
    if (ITSections != null && ITSections.Any())
    {
        foreach (var item in ITSections)
        {
            <input type="checkbox" name="Sections[0].SelectedSection" value="@item.Value" @(Html.Raw(item.Selected ? "checked=\"checked\"" : "")) /> @item.Text  <br />
        }
    }
}

If the end user selects few CheckBoxes, I want those CheckBoxes to be pre selected.

AjayV

0 2

Reply
ANSWER
User: AjayV
Replied: on Feb 17, 2023 02:45 AM
Modified: on Feb 17, 2023 03:02 AM
Report

Hi anjali600,

Please refer below sample.

Database

I have used Hobbies table.

ASP.Net MVC: Populate (Bind) CheckBoxList from Database using Entity Framework Code First Approach

I have inserted few records in the table.

ASP.Net MVC: Populate (Bind) CheckBoxList from Database using Entity Framework Code First Approach

Download SQL file

Namespaces

using System.Data.SqlClient;
using Microsoft.AspNetCore.Mvc.Rendering;

Razor PageModel (Code-Behind)

public class IndexModel : PageModel
{
    public List<SelectListItem> Hobbies { get; set; }

    public void OnGet()
    {
        //Populate Model from Database.
        this.Hobbies = PopulateHobbies();
    }

    public void OnPostSubmit(string[] hobbies)        
    {
        string constr = @"Data Source=.\SQL2019;Initial Catalog=Test;uid=sa;pwd=pass@123";
        foreach (string hobbyId in hobbies)
        { 
            List<SelectListItem> items = new List<SelectListItem>();
            using (SqlConnection con = new SqlConnection(constr))
            {
                string query = "UPDATE Hobbies SET IsSelected = 1 WHERE HobbyId = @HobbyId";
                using (SqlCommand cmd = new SqlCommand(query,con))
                {
                    cmd.Parameters.AddWithValue("@HobbyId", hobbyId);
                    con.Open();
                    cmd.ExecuteNonQuery();
                    con.Close();
                }
            }
        }
        this.Hobbies = PopulateHobbies();
    }

    private static List<SelectListItem> PopulateHobbies()
    {
        string constr = @"Data Source=.\SQL2019;Initial Catalog=Test;uid=sa;pwd=pass@123";
        List<SelectListItem> items = new List<SelectListItem>();
        using (SqlConnection con = new SqlConnection(constr))
        {
            string query = " SELECT * FROM Hobbies";
            using (SqlCommand cmd = new SqlCommand(query))
            {
                cmd.Connection = con;
                con.Open();
                using (SqlDataReader sdr = cmd.ExecuteReader())
                {
                    while (sdr.Read())
                    {
                        items.Add(new SelectListItem
                        {
                            Text = sdr["Description"].ToString(),
                            Value = sdr["HobbyId"].ToString(),
                            Selected = Convert.ToBoolean(sdr["IsSelected"])
                        });
                    }
                }
                con.Close();
            }
        }
        return items;
    }
}

Razor Page (HTML)

@page
@addTagHelper*, Microsoft.AspNetCore.Mvc.TagHelpers
@model Razor_CheckBoxList.Pages.IndexModel
@{
    ViewData["Title"] = "Home page";
}

<!DOCTYPE html>

<html>
<head>
    <meta name="viewport" content="width=device-width" />
    <title>Index</title>
</head>
<body>
    <form method="post">
        <table>
            @foreach (var hobby in Model.Hobbies)
            {
                <tr>
                    <td>
                        <input id="@hobby.Value" type="checkbox" name="hobbies" value="@hobby.Value" checked="@hobby.Selected" />
                    </td>
                    <td>
                        <label for="@hobby.Value">@hobby.Text</label>
                    </td>
                </tr>
            }
        </table>
        <br />
        <input type="submit" value="Submit" asp-page-handler="Submit" />
    </form>
</body>
</html>

Screenshot

Set CheckBox checked (selected) on page load from Database in ASP.Net Core Razor Pages

Company

Explore

Follow us

Contact Us