Insert Value From CheckBox in Database (MySQL) in asp.net using C#

Question

Insert multiple Value From CheckBox in Database (MySQL) in asp.net using C#

Satyapriya Nayak · Answer

Hi Dhanashri, Try this... Untitled Page a b c Normal 0 using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; namespace Insert_multiple_Value_CheckBoxList { public partial class _Default : System.Web.UI. Page { string connStr = ConfigurationManager .ConnectionStrings[ "ConnectionString" ].ConnectionString; SqlCommand com; protected void Button1_Click( object sender, EventArgs e) { SqlConnection con = new SqlConnection (connStr); string s1 = string .Empty; foreach ( ListItem item in this .CheckBoxList1.Items) { if (item.Selected) { s1 = item.ToString(); com = new SqlCommand ( "Insert into test values('" + s1 + "')" , con); con.Open(); int iCount = com.ExecuteNonQuery(); con.Close(); } } } } } Thanks If this post helps you mark it as answer

Satyapriya Nayak · Answer

Hi Dhanashri, Try this... Untitled Page a b c using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; namespace Insert_multiple_Value_CheckBoxList { public partial class _Default : System.Web.UI.Page { string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlCommand com; protected void Button1_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(connStr); string s1 = string.Empty; foreach (ListItem item in this.CheckBoxList1.Items) { if (item.Selected) { s1 += item + ","; } } com = new SqlCommand("Insert into test values('" + s1 + "')", con); con.Open(); int iCount = com.ExecuteNonQuery(); con.Close(); } } } Thanks If this post helps you mark it as answer

Dhanashri Patil · Answer

can you help plz .....i m having two dropdownlists which are used for 1st foe time in hr and other used for time in min but i want that both value should come in one column only for getting hh:mm like that for eg... 01:30 PM help plz

Dhanashri Patil · Answer

Thanks its working ...thanks for help

Dhanashri Patil · Answer

Thanks for helping me ...but by this code the group of data is stored in database i want that checked data should be store in one column row wise means it stores a,b,c ....i don't want this i want it should take as eg. column- Name a b c can you help me for it.....

Insert Value From CheckBox in Database (MySQL) in asp.net using C#

Answers (5)