C# Iterate Through CheckBoxList Insert Selected Items Into SQL Columns

I have a CheckBoxList that displays around 20 options. I would like to iterate through and take the selected items from the list and insert them into 5 different columns in a database.

I开发者_JAVA百科 disable the checkboxlist after 5 items are selected so I am good there. I just need to know how to iterate through and insert the selected items.

How would I get this accomplished? Thanks in advance!

you can get the checked checkboxes like this

var checkedCheckBoxes = this.Controls.OfType<CheckBox>()
                            .Where(c => c.Checked);

replace this with a container that has the checkboxes if it's not the outer most container such as a Form.

and then you can loop thru items in checkedCheckBoxes and formulate your insert statement.

Do you have list of checkboxes or CheckedListBox control?

As answers have been provided for first one already, take a look at CheckedIndices or CheckedItems properties of CheckedListBox control in case that's what you use.

Quick example:

// Cast<string>() should be replaced by whatever data type you use
var checkedItems = checkedListBox.CheckedItems.Cast<string>();
foreach (var item in checkedItems)
{
    Debug.WriteLine(item);
}

Try this:

CheckBoxList1.Items.Cast<CheckBox>()
                   .Where(s => s.Checked)
                   .Take(5);