How to Create labels dynamically from database value

Question

1.00/5 (1 vote)

See more:

How to create n no of label in web form according to database table column value.

If table contain 5 rows then I want to create 5 labels with text of row value & empty text box ahead of label

Posted 7-Dec-15 20:52pm

Shrikesh_kale

Add a Solution

Comments

Suvendu Shekhar Giri 8-Dec-15 3:03am

It's a simple task but let us see what have you tried so far.

Shrikesh_kale 8-Dec-15 4:41am

"\n" are not working

Shrikesh_kale 8-Dec-15 4:41am

using (SqlCommand cmd = new SqlCommand(sqlcommand))
{
using (SqlDataAdapter sda = new SqlDataAdapter())
{
cmd.Connection = connection;
sda.SelectCommand = cmd;
using (DataTable dt = new DataTable())
{
sda.Fill(dt);

if (dt.Rows.Count > 0)
{
TableRow rw = new TableRow();
Label NewLabel = new Label();
NewLabel.ID = "Label";
for (int i = 0; i < dt.Rows.Count; i++)
{

NewLabel.Text += dt.Rows[i][0].ToString() + "\n";

}
this.form1.Controls.Add(NewLabel);

}

//SqlCommand cmd = new SqlCommand("SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '" + tablename + " ' ORDER BY ORDINAL_POSITION", connection);

//SqlDataReader dr = cmd.ExecuteReader();

//if (dr.Read())

//{
// for (int i = 0; i < length; i++)
// {
// Label NewLabel = new Label();
// NewLabel.ID = "Label" + dr["COLUMN_NAME"].ToString();
// NewLabel.Text = dr["COLUMN_NAME"].ToString();
// this.form1.Controls.Add(NewLabel);
// }

//}

connection.Close();
}
}
}

Member 13738315 10-Apr-18 7:46am

pls send me the coding for same problem in vb.net. I want to display the data from database to lables for attendance form. Because i registered new student details, the attendance form should be add the student name, idno automataically that are displayed in lables dynamically. Another one attendance form each student detail have a combobox for mark the attendance present or opsent. i think you did understand.pls give me the code for attendance.pls help me...

1 solution

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)

Praveen_P · Accepted Answer · 2015-12-07T22:28:00

Solution 1

Hi,

Please try the following code , 'n' is the row value from your table

C#

for (int i = 0; i < n; i++)
        {

            Label lbl = new Label();
            lbl.ID = "Label" + i.ToString();

            Panel1.Controls.Add(lbl); // add the label to a panel
        }

Posted 7-Dec-15 22:28pm

Praveen_P

Updated 7-Dec-15 22:41pm

v2

Comments

Shrikesh_kale 8-Dec-15 4:58am

Can you help me for table because i need text box also.

Praveen_P 8-Dec-15 7:02am

Modify the above code by including

TextBox txtbox= new TextBox();
txtbox.ID = "txt" + i.ToString();

Panel1.Controls.Add(txtbox);

Member 13738315 10-Apr-18 7:46am

pls send me the coding for same problem in vb.net. I want to display the data from database to lables for attendance form. Because i registered new student details, the attendance form should be add the student name, idno automataically that are displayed in lables dynamically. Another one attendance form each student detail have a combobox for mark the attendance present or opsent. i think you did understand.pls give me the code for attendance.pls help me...

Praveen_P 10-Apr-18 7:53am

Post your above question as a separate thread with tag VB.Net , also please provide what you have tried so far and where you got stuck.. good luck

Praveen_P 10-Apr-18 8:30am

Because i dont know VB.Net and if you post it as a separate question you would definitely got some expert advice