how to generate dynemic check box from the database?

Question

4.00/5 (1 vote)

See more:

i have a table in my Database and according to number of record in table the checkbox created.

Example:- i have 5 record in table so i want 5 checkbox created automatically.

the previous code that i send you is written in the pageload event.

the problem is in the checkbox that are created everytime when pageload event fire.

I also want to use that checkbox ID in the checkbox event.

Please help if you know the answer.

Posted 3-Apr-14 23:44pm

rohitkava

Add a Solution

Comments

Tom Marvolo Riddle 4-Apr-14 5:58am

post your code

ZurdoDev 4-Apr-14 6:29am

Dynamic controls should be added in the Page_Init event otherwise you may have problems with viewstate.

ritav1991 5-Apr-14 6:30am

how to display question and answer option type wise.for example option type if multipal choice(single answer),multipal choice (multipal answer),image list control,date.
if select option type so display question and answer in page so how to create.

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

manvendra patel · Answer 1 · 2014-04-04T00:42:00

i think u should use checkboxlist .............

it bind your record and generate number of checkboxes...

for example

C#

protected void Page_Load(object sender, EventArgs e)
    {
         if (!Page.IsPostBack)
        {
            using (SqlConnection con=new SqlConnection ())
            {
con.ConnectionString =ConfigurationManager.ConnectionStrings ["ConnectionString"].ToString ();
                con.Open ();
                using (SqlCommand cmd = new SqlCommand())
                {
                    cmd.CommandText = "select * from [Table]";
                    cmd.Connection = con;
                    using (DataSet ds = new DataSet())
                    {
                        using (SqlDataAdapter da = new SqlDataAdapter(cmd))
                        {
                            da.Fill(ds);
                            CheckBoxList1.DataSource = ds;
                            CheckBoxList1.DataTextField = "name";
                            CheckBoxList1.DataValueField = "Employeeid";
                            CheckBoxList1.DataBind();
                        }
                    }
                }

or try this link

http://www.aspsnippets.com/Articles/Bind-CheckBoxList-from-Database-in-ASPNet.aspx[^]

sandeep_kumar · Answer 2 · 2014-04-04T01:25:00

Hi,

You need to write the code in a condition that will restrict

C#

public void Page_Load(object sender, EventArgs e)
{
  if(!this.IsPostBack)
  {
     using (SqlConnection con=new SqlConnection ())
            {
              //your connection string
                con.Open ();
                using (SqlCommand cmd = new SqlCommand())
                {
                   // your sql command
                    using (SQLDataReader rd = cmd.ExecuteReader())
                    {
                        while(rd.Read())
                        {
                            // suppose you have a panel in your page as panel1
                            CheckBox chk = new CheckBox();
                            chk.ID=string.Fromat("CheckBox_{0}", rd["PrimaryKey/AnyValue"]);
                           // bind event to checkbox
                            chk.Checked+= new EventHandler(checkbox_checked);
                             
                        }
                    }
                }
             } 
  }
}

public void checkbox_checked(object sender, EventArgs e)
{
    //your code----------------
}

sandeep_kumar · Answer 3 · 2014-04-04T01:45:00

You also need to add this check box in panel

so here is the code.

C#

while(rd.Read())
                        {
                            // suppose you have a panel in your page as panel1
                            CheckBox chk = new CheckBox();
                            chk.ID=string.Fromat("CheckBox_{0}", rd["PrimaryKey/AnyValue"]);
                           // bind event to checkbox
                            chk.Checked+= new EventHandler(checkbox_checked);
                            panel1.Controls.Add(chk);    
                        }

how to generate dynemic check box from the database?

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0