Check CheckBoxes based on database value using C# in ASP.Net

BigHeart

SOLVED CLOSED ACTIVE ANSWERED
User: BigHeart
Posted: on Apr 07, 2016 02:10 AM
Forum: ASP.Net Web Forms
Answer: 1
Views: 9829

I have Checkbox list from database

and selection list also from database

i can fill check boxlist from db in below

i have one datatable for selection items

i want that values to be selected in this checklist.

dt pagelist have 1 to 10

dt checklist have 1,3,5,7

DataTable dt = obj.checklist();
 public void pagelist()
    {
        DataTable pl = obj.pagelist();
         foreach (DataRow row in pl.Rows)
        {
            ListItem item = new ListItem();
            item.Text = row["Previlage_pageName"].ToString();
            item.Value = row["Previliges_ID"].ToString();
            CHpagelist.Items.Add(item);
        }
         
    }

Download FREE API for Word, Excel and PDF in ASP.Net

Shashika...

0 3

Reply
ANSWER
User: Shashikant
Replied: on Apr 07, 2016 03:43 AM
Modified: on Apr 07, 2016 04:59 AM
Report

Hi,

Please refer below code.

HTML

<asp:CheckBoxList ID="chkList" runat="server" RepeatColumns="5" RepeatDirection="Horizontal">
</asp:CheckBoxList>

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        DataTable pagelist = new DataTable();
        pagelist.Columns.Add("Page");
        pagelist.Rows.Add("1");
        pagelist.Rows.Add("2");
        pagelist.Rows.Add("3");
        pagelist.Rows.Add("4");
        pagelist.Rows.Add("5");
        pagelist.Rows.Add("6");
        pagelist.Rows.Add("7");
        pagelist.Rows.Add("8");
        pagelist.Rows.Add("9");
        pagelist.Rows.Add("10");
        chkList.DataSource = pagelist;
        chkList.DataTextField = "Page";
        chkList.DataValueField = "Page";
        chkList.DataBind();
        DataTable checklist = new DataTable();
        checklist.Columns.Add("check");
        checklist.Rows.Add("1");
        checklist.Rows.Add("3");
        checklist.Rows.Add("5");
        checklist.Rows.Add("7");
        foreach (ListItem item in chkList.Items)
        {
            if (checklist.AsEnumerable().Select(x => x["check"]).ToArray().Contains(item.Value))
            {
                item.Selected = true;
            }
        }
    }
}

Screenshot

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Check CheckBoxes based on database value using C# in ASP.Net

Company

Explore

Follow us

Contact Us