how to create number of checkboxs according to database

Question

how to create number of checkbox according to no of data present in database and checkbox text will comes from the data present in database dynamically

Pradeep · Answer

SqlConnection con = new SqlConnection(connStr); con.Open(); str = "select * from tableName"; 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"; // 'item' is column name which you want display data as checkbox text CheckBoxList1.DataValueField = "id"; CheckBoxList1.DataBind(); } con.Close();

Susanta Rout · Answer

i got some new things every of your replay

Pradeep · Answer

add this place holder in aspx page. and then take database value and use foreach loop istead of for loop and assign databse value checkboxes.

Susanta Rout · Answer

i got some idea from your code.i want to put this table inside a particular div or panel.then how will i put this inside that particular div

Pradeep · Answer

plhCategory.Controls.Add(new LiteralControl(" ")); for (int j = 1; j { plhCategory.Controls.Add(new LiteralControl(" ")); for (int i = 0; i { plhCategory.Controls.Add(new LiteralControl(" " + i.ToString() + " ")); } plhCategory.Controls.Add(new LiteralControl(" ")); } plhCategory.Controls.Add(new LiteralControl(" ")); you can replace i or j to data present in database .

Susanta Rout · Answer

i am a fresher.can you send me a just small example if you have time to share.

Pradeep · Answer

ok, then use place holder and add Div , table ,checkbox in server side dynamically.

Susanta Rout · Answer

i got you n the answer too.but i want to show checkboxlist in a with 10 checkbox in every column,

how to create number of checkboxs according to database

Answers (8)