Insert DropDownList Selected Values as comma separated to database in ASP.Net

Hi ramasekhar,

I have made one sample that full-fill your requirement.

HTML

<div>
    Days:
    <asp:CheckBoxList ID="chkDays" runat="server">
        <asp:ListItem Text="Sunday" Value="0"></asp:ListItem>
        <asp:ListItem Text="Monday" Value="1"></asp:ListItem>
        <asp:ListItem Text="Tuesday" Value="2"></asp:ListItem>
        <asp:ListItem Text="Wednesday" Value="3"></asp:ListItem>
        <asp:ListItem Text="Thursday" Value="4"></asp:ListItem>
        <asp:ListItem Text="Friday" Value="5"></asp:ListItem>
        <asp:ListItem Text="Saturday" Value="6"></asp:ListItem>
    </asp:CheckBoxList>
    <br />
    <asp:Button ID="btnUpdate" runat="server" Text="Save" OnClick="InsertDays" />
</div>

Code

protected void InsertDays(object sender, EventArgs e)
{
    string item = string.Empty; ;
    for (int i = 0; i < chkDays.Items.Count; i++)
    {
        if (chkDays.Items[i].Selected == true)
        {
            item += chkDays.Items[i].Text.Trim() + ",";
        }
    }
    string finalItem = item.Remove(item.Length - 1, 1);
    using (SqlConnection conn = new SqlConnection())
    {
        conn.ConnectionString = ConfigurationManager.ConnectionStrings["conString"].ConnectionString;
        using (SqlCommand cmd = new SqlCommand("InsertDays"))
        {
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Connection = conn;
            conn.Open();
            cmd.Parameters.Clear();
            cmd.Parameters.AddWithValue("@Days", finalItem);
            cmd.ExecuteNonQuery();
            conn.Close();
        }
    }
}

Screenshot