ask about checkboxlist

romasha ali

13y2.1k.NET

i want to store checked items of check box list in database and i got the code but it did not work when i run this code it does not show items in database column rather than it shows "checkbox.DataValueField" in database..code snippet is given below...

kindly help me ...

public partial class courses : System.Web.UI.Page

{

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);

protected void Page_Load(object sender, EventArgs e)

{ }

protected void SqlDataSource1_Selecting(object sender, SqlDataSourceSelectingEventArgs e)

{ string interests = string.Empty;

foreach (ListItem item in this.checkbox.Items)

if (item.Selected)

{

interests += item.Text;

SqlCommand cmd = new SqlCommand("Insert into tbl3(courseId) values('" + interests + "')", con); //Write Your Query to insert into database table

con.Open();

int iCount = cmd.ExecuteNonQuery();

con.Close();

}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Satyapriya Nayak13y ago
Accepted answer
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 btn_insert_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(); com.ExecuteNonQuery(); con.Close(); } } Response.Write("Inserted Successfully"); } } }
romasha ali13y ago
thanx alot its really worked as i want
Bryian Tan13y ago
Hello,

Did you post the wrong code? The reason I'm asking because the code iterating the checboxlist look fine but the code is trying to insert selected text into courseID column. Maybe the question is about checkboxlist binding? Here is the code snippet to data bind checkboxlist.

CheckBoxList1.DataSource = "yourdatasource";
        CheckBoxList1.DataTextField = "Column Name to display as Text";
        CheckBoxList1.DataValueField = "Column Name to display as Value";
        CheckBoxList1.DataBind();