how to Dynamically add checkbox and column values from db

Question

hi how to Dynamically add checkbox and retrieve column values from database using in asp.net c#

Satyapriya Nayak · Answer

Use CheckBoxList Untitled Page 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 Bind_checkboxlist { public partial class _Default : System.Web.UI.Page { string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlCommand com; SqlDataAdapter sqlda; DataSet ds; string str; protected void Page_Load(object sender, EventArgs e) { SqlConnection con = new SqlConnection(connStr); con.Open(); str = "select * from test"; com = new SqlCommand(str, con); sqlda = new SqlDataAdapter(com); DataTable dt = new DataTable(); sqlda.Fill(dt); if (dt.Rows.Count - 1 > 0) { CheckBoxList1.DataSource = dt; CheckBoxList1.DataTextField = "items"; CheckBoxList1.DataValueField = "id"; CheckBoxList1.DataBind(); } con.Close(); } } }

Satyapriya Nayak · Answer

http://www.c-sharpcorner.com/UploadFile/sushmita_kumari/dynamiccheckbox101112006231058PM/dynamiccheckbox1.aspx

how to Dynamically add checkbox and column values from db

Answers (2)