How to bind values from database to a checkboxlist.

Question

User1052662409 posted

Hi All,

I am inserting into datanbase some selected values from a checkboxlist by using comma for seperating them. For tthat i am using the code below.

protected void Select_Risk()
    {
        StringBuilder sb = new StringBuilder();
        for (int i = 0; i < CBLRisk.Items.Count; i++)
        {
            if (CBLRisk.Items[i].Selected)
            {
                sb.Append(CBLRisk.Items[i].Value + ", ");
            }
        }
        lblRisk.Text = sb.ToString();



    }

later i am inserting the lblRisk text into database.

Now I want to retrieve these values from database to bind the same checkboxlist.

The values stored in my database below.

how to bind those values to checkbox list as selected (see below image)

Thanks

Answer 1

User1724605321 posted

Hi demoninside9,

Code below is for your reference :

<asp:CheckBoxList ID="chklstStates" runat="server">
                <asp:ListItem Text="Alabama" Value="Alabama"></asp:ListItem>
                <asp:ListItem Text="Alaska" Value="Alaska"></asp:ListItem>
                <asp:ListItem Text="Arizona" Value="Arizona"></asp:ListItem>
                <asp:ListItem Text="Arkansas" Value="Arkansas"></asp:ListItem>
                <asp:ListItem Text="California" Value="California"></asp:ListItem>
                <asp:ListItem Text="Connecticut" Value="Connecticut"></asp:ListItem>
                <asp:ListItem Text="Florida" Value="Florida"></asp:ListItem>
                <asp:ListItem Text="Delaware" Value="Delaware"></asp:ListItem>
                <asp:ListItem Text="Hawaii" Value="Hawaii"></asp:ListItem>
                <asp:ListItem Text="Kentucky" Value="Kentucky"></asp:ListItem>
                <asp:ListItem Text="Maryland" Value="Maryland"></asp:ListItem>
                <asp:ListItem Text="New Jersey" Value="New Jersey"></asp:ListItem>
                <asp:ListItem Text="New York" Value="New York"></asp:ListItem>
            </asp:CheckBoxList>

You could bind the checkbox list by :

            var testvalues = "Alabama,Hawaii";
            var values = testvalues.Split(',');
            foreach (var item in values)
            {
                ListItem listItem = this.chklstStates.Items.FindByText(item);

                if (listItem != null) listItem.Selected = true;
              
            }     

You could find the values by:

  ListItem listItem = this.chklstStates.Items.FindByValue(item);

Best Regards,

Nan Yu

Answer 2

User-1716253493 posted

Store the seletected value sparate by comma without space

Answer 3

User1052662409 posted

.