dynamically added label

Question

1.50/5 (4 votes)

See more:

i want is that, when i fetch data from database then labels dynamically added to my form.

i have a code but this show only one data, i want total result of query generate automatically label and set data into label.

my code is .

`

C#

con.Open();
               DataTable table = new DataTable();
               string sqlText = "SELECT DATEDIFF(DAY, [meas_duedate], GETDATE()) , meas_id, client_id FROM tlb_meas_master"
               SqlCommand cmd = new SqlCommand(sqlText, con);

               SqlDataReader dr = cmd.ExecuteReader();
               while (dr.Read())
               {

                   }
                   lbl_date.Text = dr.GetValue(0).ToString();
                   lbl_mea_id.Text = dr.GetValue(1).ToString();
                   lbl_cli_id.Text = dr.GetValue(2).ToString();

               }
               con.Close();
           }
           catch (Exception ex)
           {
               MessageBox.Show(ex.Message + "\n" + ex.Message);
               con.Close();
           }

`please help me....

Posted 16-Dec-15 11:08am

Member 10484162

Updated 16-Dec-15 12:52pm

barneyman

v2

Add a Solution

Comments

Sergey Alexandrovich Kryukov 16-Dec-15 17:15pm

C?!
—SA

Member 10484162 16-Dec-15 17:32pm

? you understand my question ?

Sergey Alexandrovich Kryukov 16-Dec-15 17:49pm

You tagged the question as "C". What are you talking about?
If this is C#, the problem is trivial. What is your lbl_* objects. Are they already created (constructed)? If not, create and insert them. What's the problem?
—SA

Member 10484162 16-Dec-15 17:53pm

yes this is c# winforms, i want when my sql query run then winform create dynamically label and value set from database. sory for my bad english hope u understand my problem

Member 10484162 16-Dec-15 17:56pm

c# winform, i have a application and in application i have a notification panel, i want when user login then notification panel show all record of this user. i use datagridview but this is not suitable, i want a label to show data, there is many datain my database so please help me how to create dynamically label and how to populate data into dynamically created labels.

Member 10484162 16-Dec-15 17:57pm

this is pageload code.

private void MainScr_Load(object sender, EventArgs e)
{
con = new SqlConnection("Data Source = HAMMAD-PC\\SQLEXPRESS; Integrated Security = true; Initial Catalog = ubm_db");

try
{
Label newLabel;
int n = 5;
con.Open();
DataTable table = new DataTable();
string sqlText = "SELECT DATEDIFF(DAY, [meas_duedate], GETDATE()) , meas_id, client_id FROM tlb_meas_master";
SqlCommand cmd = new SqlCommand(sqlText, con);

SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{

lbl_date.Text = dr.GetValue(0).ToString();
lbl_mea_id.Text = dr.GetValue(1).ToString();
lbl_cli_id.Text = dr.GetValue(2).ToString();

}
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + "\n" + ex.Message);
con.Close();
}

}

CHill60 17-Dec-15 10:48am

I thought you said it was WinForms? Pageload is not winforms

2 solutions

Solution 1

"Create label dynamically" simply means

C#

Label myLabel = new Label();
// then you can assign Text, Left, Top, other properties

Then you need to add a label to some parent control:

C#

myLabel.Parent = parent;
// the same as
parent.Controls.Add(myLabel);

And so on…

—SA

Posted 16-Dec-15 13:09pm

Sergey Alexandrovich Kryukov

Comments

Member 10484162 17-Dec-15 15:51pm

thanks sir, but i want all data show in label, for example sql query have a four result then winform create 4 label dynamically and set column value of sqlserver. hope u understand sir, and sorry for my bad languange.

Sergey Alexandrovich Kryukov 17-Dec-15 15:54pm

Didn't I answer your question already? You asked about adding a label dynamically. Remaining step is assigning some string values from your data to the Text property, myLabel.Text = ...
—SA

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)

BillWoodruff · Accepted Answer · 2015-12-16T16:51:00

You need to add the created Label to a Form or other ContainerControl's ControlCollection to make it 'show:

LabelPanel.Controls.Add(newLabel);

And, you'll need to set the Label's position/location to 'show it where you want it to appear in its container:

newLabel.Location = new Point(100,200);

If you set the Dock Property of the Label, where it appears in its ContainerControl will be dependent on the 'DockStyle settig ... and what other Controls are "in" the host Control's ControlCollection that are also docked:

newLabel.Dock = DockStyle.Top;