how to create number of checkboxs according to database
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
Loading
8 Replies
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
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;
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();
CheckBoxList1.DataValueField = "id";
CheckBoxList1.DataBind();
}
con.Close();
Susanta RoutPosted Sep 7, 2015, 2:12 AM
PradeepPosted Sep 7, 2015, 2:08 AM
Susanta RoutPosted Sep 7, 2015, 2:01 AM
PradeepPosted Sep 7, 2015, 1:50 AM
for (int j = 1; j <= 10; j++)
{
plhCategory.Controls.Add(new LiteralControl("
for (int i = 0; i < 10; i++)
{
plhCategory.Controls.Add(new LiteralControl("" + i.ToString() + ""));
}
plhCategory.Controls.Add(new LiteralControl("
}