Save CheckBoxList Items in Database in ASP.Net

Check the below example.

HTML

<div>
    <asp:DropDownList ID="ddlslno" runat="server">
        <asp:ListItem Text="text1" />
        <asp:ListItem Text="text2" />
    </asp:DropDownList>
    <asp:DropDownList ID="DropDownList1" runat="server">
        <asp:ListItem Text="text1" />
        <asp:ListItem Text="text2" />
    </asp:DropDownList>
    <asp:DropDownList ID="ddlname" runat="server">
        <asp:ListItem Text="text1" />
        <asp:ListItem Text="text2" />
    </asp:DropDownList>
    <asp:Label ID="lblError" runat="server" />
    <asp:CheckBoxList ID="chkFruits" runat="server">
        <asp:ListItem Text="Mango" Value="10"></asp:ListItem>
        <asp:ListItem Text="Apple" Value="20"></asp:ListItem>
        <asp:ListItem Text="Pineapple" Value="30"></asp:ListItem>
        <asp:ListItem Text="Orange" Value="40"></asp:ListItem>
    </asp:CheckBoxList>
    <asp:Button Text="Save" runat="server" OnClick="Save" />
</div>

C#

protected void Save(object sender, EventArgs e)
{
    int amount = 0;
    string apple = "0", orange = "0", pineapple = "0", mango = "0";
    for (int j = 0; j <= chkFruits.Items.Count - 1; j++)
    {
        if (chkFruits.Items[j].Selected)
        {
            switch (chkFruits.Items[j].Text.ToLower())
            {
                case "apple":
                    apple = chkFruits.Items[j].Value;
                    break;
                case "orange":
                    orange = chkFruits.Items[j].Value;
                    break;
                case "pineapple":
                    pineapple = chkFruits.Items[j].Value;
                    break;
                case "mango":
                    mango = chkFruits.Items[j].Value;
                    break;
                default:
                    break;
            }
            amount += Convert.ToInt32(chkFruits.Items[j].Value);
        }
    }
    string slno = Convert.ToString(ddlslno.SelectedItem.Text);
    string name = Convert.ToString(ddlname.SelectedItem.Text);
    string section = Convert.ToString(DropDownList1.SelectedItem.Value);

    insertGameRecord(slno, name, section, apple, orange, pineapple, mango, amount);

}
private void insertGameRecord(string slno, string name, string section, string apple, string orange, string pineapple, string mango, int amount)
{
    try
    {
        string strConnectionString = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
        SqlConnection myConnect = new SqlConnection(strConnectionString);
        string strCommandText = "INSERT Table_1(slno, Name, section, apple, orange, pineapple, mango) Values(@slno, @name, @section, @apple, @orange, @pineapple, @mango)";
        SqlCommand cmd = new SqlCommand(strCommandText, myConnect);
        cmd.Parameters.AddWithValue("@slno", slno);
        cmd.Parameters.AddWithValue("@name", name);
        cmd.Parameters.AddWithValue("@section", section);
        cmd.Parameters.AddWithValue("@apple", apple);
        cmd.Parameters.AddWithValue("@orange", orange);
        cmd.Parameters.AddWithValue("@pineapple", pineapple);
        cmd.Parameters.AddWithValue("@mango", mango);
        cmd.Parameters.AddWithValue("@amount", amount);
        myConnect.Open();
        int result = cmd.ExecuteNonQuery();
        if (result > 0)
        {
            lblError.Text = "Record Updated";
        }
        else
        {
            lblError.Text = "Update fail";
        }
        myConnect.Close();
    }
    catch (Exception)
    {
        lblError.Text = "Please enter correct data";
    }
}

Screenshot

Form selection

Values in code