how to check uncheck multiple items in CheckBoxList based on DataTable value

Question

I have CheckBoxList I want to Check multiple items based on database value here is my code

String TargetQuery = "Select RoleID from t_Et_Role_Staff_Combination where  EmployeeID='" + EmployeeID + "'";    
SqlDataAdapter adapt = new SqlDataAdapter(TargetQuery, DBcon.con);        
DataTable dtcheck = new DataTable();
adapt.Fill(dtcheck);

protected void Page_Load(object sender, EventArgs e)
{    
    for (int i = 0; i < dtcheck.Rows.Count; i++)
    {    
        CheckBoxList1.SelectedValue = dtcheck.Rows[i][0].ToString();        
    }
}

but this checked only one item( the last item) from DataTable the previous items are not selected

[based on my database value administrator and aaa should be checked but now only aaa is selected]

CheckBoxList1.SelectedValue for each iteration of your for loop you are setting value to the same CheckBox whose name is CheckBoxList1 — MajkeloDev
– MajkeloDev, Commented Nov 16, 2015 at 8:34
Every CheckBoxList item has a Boolean flag Selected. Use this. — Yeldar Kurmangaliyev
– Yeldar Kurmangaliyev, Commented Nov 16, 2015 at 8:35
thank you but its Checkboxlist not checkbox. it has multiple items. i want to check by item value — user3536676
– user3536676, Commented Nov 16, 2015 at 8:39
Is your Checkboxlist selection mode is MultiExtended or single ? — Suprabhat Biswal
– Suprabhat Biswal, Commented Nov 16, 2015 at 9:12

Suprabhat Biswal · Accepted Answer · 2015-11-16 10:14:20Z

1

You need to iterate inside Checkboklist items not in datatable.

if (dtcheck != null && dtcheck.Rows.Count > 0) /* Prevents from null reference exception */
{   
    for (int i = 0; i < CheckBoxList1.Items.Count; i++)
    {
        if ( i < dtcheck.Rows.Count) /* Ensure and prevents from Index out of range exception */
        {
            bool flag = default(bool);
            Boolean.TryParse(dtcheck.Rows[i][0].ToString(), out flag);
            CheckBoxList1.Items[i].Selected = flag;
        }
    }
}

Since you have updated your post and rest of detail above mentioned code won't work in that case. As mentioned your database value is administrator but your checkboxlist text is Administrator both are different you need something like following that matches the text and ignore the case.

for (int i = 0; i < dtcheck.Rows.Count; i++)
{    
    string compareText = dtcheck.Rows[i][0].ToString();
    var vCheckBoxItem = CheckBoxList1.Items.Cast<ListItem>()
                        .FirstOrDefault(x => x.Text.Equals(compareText, StringComparison.CurrentCultureIgnoreCase));
    if (vCheckBoxItem != null)
        vCheckBoxItem.Selected = true;      
}

edited Nov 16, 2015 at 10:14

answered Nov 16, 2015 at 8:49

Suprabhat Biswal

3,2561 gold badge23 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

user3536676 Over a year ago

its not working CheckBoxList1.Items[i].Checked = flag; .checked is not recognize.

Suprabhat Biswal Over a year ago

@user3536676: After seeing your updated code I have updated my post. Try it, Hope this works for you.

Suprabhat Biswal Over a year ago

Sorry, It's not Checked actually it's Selected.

user3536676 Over a year ago

thank you still not working but i used value not Items Name

Suprabhat Biswal Over a year ago

Can you just share markup for checkboxlist and how you are binding checkboxlist and what data does datatable have?

Collectives™ on Stack Overflow

how to check uncheck multiple items in CheckBoxList based on DataTable value

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related