Insert multiple values selected in checkbox in database

1.Create Table

 

Create Table HOBBIES
(
HobbyId INT identity1,1) NOT NULL Primary Key,
Hobby VARCHAR(100),
)

 

2.

 

 

3.using System;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;

public partial class ASPNET_MultipleCheckBox : System.Web.UI.Page
{
public static string conString = Convert.ToString(ConfigurationManager.ConnectionStrings["dbconnect"].ConnectionString);
SqlCommand com;
protected void Page_Load(object sender, EventArgs e)
{
}
protected void btnInsert_Click(object sender, EventArgs e)
{
try
{
SqlConnection con = new SqlConnection(conString);
string s1 = string.Empty;
foreach (ListItem item in this.chkHobbies.Items)
{
if (item.Selected)
{
s1 = Convert.ToString(item);
com = new SqlCommand("Insert into HOBBIES(Hobby)values('" + s1 + "')", con);
con.Open();
com.ExecuteNonQuery();
con.Close();
}
}
Response.Write("Inserted Successfully");
}
catch (Exception err)
{
Response.Write(err.Message);
}
}
}

Hi David Miller thnaks for writing below links i hope helpful for you..:)

 

http://www.aspsnippets.com/Articles/Insert-multiple-values-from-CheckBoxList-to-Database-in-ASPNet.aspx

 

http://www.codeproject.com/Questions/620401/Csharp-NET-how-to-save-multiple-checkbox-values-in

 

http://www.neerajcodesolutions.com/2014/12/how-to-insert-multiple-checkboxlist.html 

http://www.aspsnippets.com/Articles/Insert-multiple-values-from-CheckBoxList-to-Database-in-ASPNet.aspx