ASP/C#/SQL - Checkbox List - Store multiple values in database where checked : I have a checkboxlist. 

    <asp:CheckBoxList ID="cbBowelSounds" runat="server">
                        <asp:ListItem Text="&nbsp;&nbsp;<span style=font-weight:normal;>1 Quadrant</span>" Value="1 Quadrant" />
                        <asp:ListItem Text="&nbsp;&nbsp;<span style=font-weight:normal;>2 Quadrant</span>" Value="2 Quadrant" />
                        <asp:ListItem Text="&nbsp;&nbsp;<span style=font-weight:normal;>Hypo</span>" Value="Hypo" />
                        <asp:ListItem Text="&nbsp;&nbsp;<span style=font-weight:normal;>Hyper</span>" Value="Hyper" />
                        <asp:ListItem Text="&nbsp;&nbsp;<span style=font-weight:normal;>Normal</span>" Value="Normal" />
                     </asp:CheckBoxList>

You can select multiple values. I want to store those values in a SQL database. At first I thought I would create 5 columns in the sql table and I would add each selected value to the correct column. That didnt work. 

Then I found this snippet. 

    var s = cbBowelSounds.SelectedValue;
    string[] values = s.Split(',');
    foreach (ListItem item in cbBowelSounds.Items) item.Selected = values.Contains(item.Value);

That was great... until the database reported this for the answer. System.String[]

So, what can I do here? whether it's one column with multiple values or 5 columns where the first listitem writes to column 1, etc., It doesn't matter me. I just need the values selected to be sent to the DB. 

Thank you
