Insert all selected (checked) ASP.Net CheckBox items into database using C#

Hi micah,

Refer below sample code. You need to pass the parameters that are required for insert.

HTML

<asp:CheckBoxList ID="chkHobbies" runat="server">
</asp:CheckBoxList>
<br />
<asp:Button ID="btnInsert" runat="server" Text="Button" OnClick="OnInsertHobbies" />

Namespaces

using System.Configuration;
using System.Data.SqlClient;

Code

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        this.BindCheckBoxList();
    }
}

private void BindCheckBoxList()
{
    using (SqlConnection conn = new SqlConnection())
    {
        conn.ConnectionString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
        using (SqlCommand cmd = new SqlCommand())
        {
            cmd.CommandText = "select * from Hobbies";
            cmd.Connection = conn;
            conn.Open();
            using (SqlDataReader sdr = cmd.ExecuteReader())
            {
                while (sdr.Read())
                {
                    ListItem item = new ListItem();
                    item.Text = sdr["Description"].ToString();
                    item.Value = sdr["HobbyId"].ToString();
                    item.Selected = Convert.ToBoolean(sdr["IsSelected"]);
                    chkHobbies.Items.Add(item);
                }
            }
            conn.Close();
        }
    }
}

protected void OnInsertHobbies(Object sender, EventArgs e)
{
    foreach (ListItem item in chkHobbies.Items)
    {
        if (item.Selected)
        {
            string conString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
            using (SqlConnection con = new SqlConnection(conString))
            {
                using (SqlCommand cmd = new SqlCommand("INSERT INTO HobbiesDetails (HobbyId,Description) VALUES (@HobbyId,@Description)"))
                {
                    cmd.Connection = con;
                    cmd.Parameters.AddWithValue("@HobbyId", item.Value);
                    cmd.Parameters.AddWithValue("@Description", item.Text);
                    con.Open();
                    cmd.ExecuteNonQuery();
                    con.Close();
                }
            }
        }
    }
    this.BindCheckBoxList();
}