Insert multiple values selected in checkbox in database

Question

How to insert multiple values selected in checkbox in database.

Amit Singh · Answer

1.Create Table Create Table HOBBIES ( HobbyId INT identity11) NOT NULL Primary Key Hobby VARCHAR(100) ) 2. Hobbies: Swimming Dancing Video Games Singing Gardening onclick=btnInsert_Click /> 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); } } }

Krishna Rajput Singh · Answer

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

Amit Singh · Answer

http://stackoverflow.com/questions/26082288/how-to-save-multiple-selected-checkboxlist-to-database-asp-net-c-sharp

Chandu Kumawat · Answer

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