how to add label dynamically and bind sql data to label

Question

5.00/5 (1 vote)

See more:

I m creating website in that i want to display data from sql table into label in asp.net.but i want that label should be added dynamically and bind data to label.
if the sql table contains 2 rows the label should be 2 added and bind data

Posted 9-May-12 0:42am

Manohar Khillare

Add a Solution

6 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)

Michael_Jacsi · Answer 1 · 2012-05-09T01:11:00

Solution 1

try This one ....

C#

Label lblfirst = new Label();

Label lblsecond = new Label();

lblfirst.Text="bind data from DB";

lblsecond.Text="bind data from DB";

Posted 9-May-12 1:11am

Michael_Jacsi

Updated 9-May-12 9:54am

v2

Comments

Manohar Khillare 9-May-12 8:03am

i want dynamically add label

Sandeep Mewara 9-May-12 8:27am

This does exactly what you asked for. Now, if this is not what you need than you need to read and then post your questions using right words.

5! to answer.

Deepak_Sharma_ · Answer 2 · 2012-05-09T02:10:00

Hi,

You can use following code to add as many labels as rows in your table dynamically:

C#

protected void Page_Load(object sender, EventArgs e)
        {
            AddDynamicLabels();
        }

        private void AddDynamicLabels()
        {
            string ConString = ConfigurationManager.ConnectionStrings["ConString"].ConnectionString;
            SqlConnection con = new SqlConnection(ConString);
            string CmdString = "Select EmployeeID, FirstName, HireDate FROM Employees ORDER BY Salary DESC";
            SqlCommand cmd = new SqlCommand(CmdString, con);
            con.Open();
            SqlDataReader reader = cmd.ExecuteReader();
            while (reader.Read())
            {
                Label lbl = new Label();
                lbl.Text = reader["FirstName"].ToString();
                lbl.BackColor = System.Drawing.Color.Orange;
                lbl.BorderStyle = BorderStyle.Solid;
                lbl.BorderWidth = 1;
                this.Controls.Add(lbl);
            }
            con.Close();
        }

cyclopic · Answer 3 · 2012-05-09T01:18:00

Hello ...

Considering the label id as LblOne and SqlDataReader rd1 you can simply code this :

in the design page :

<asp:Label ID="LblOne" runat="server" Text="" />

in the code behind : VB.Net code

VB

LblOne.Text = String.Empty  ' to clear the label

While rd1.read()  
LblOne.Text += rd1("firldName").ToString 

End While

cyclopic · Answer 4 · 2012-05-09T01:39:00

Solution 3

Oooohh .. i've misunderstood your ask...

sorry

Cyclopic

Posted 9-May-12 1:39am

cyclopic

Comments

Manohar Khillare 9-May-12 8:04am

is there way to add label in table td tag in source file

cyclopic 9-May-12 8:46am

look at solution 4

Cyclopic

cyclopic 9-May-12 8:51am

The function add label in td dynamicaly created but if you want to add in "static" td then :
<table>
<tr>
<td runat="server" id="td01"></td>
</tr>
</table>

and in codebehind..;
Dim TmpLabel As New Label
TmpLabel.Text = "Vive la France"
td01.Controls.Add(TmpLabel)

Bye

anish_singh · Answer 5 · 2012-05-09T02:03:00

Solution 5

Try This..

C#

Label lbl1 = new Label();
 
Label lbl2 = new Label();
 
lbl1 .Text="bind data from DB";
 
lbl2 .Text="bind data from DB";

p1.Controls.Add(lab);
pa.Controls.Add(lab);

.ASPX Page

XML

<p id = "P1" runat = "server"><p>

<p id = "P2" runat="server">
<p>

Posted 9-May-12 2:03am

anish_singh

Updated 9-May-12 9:56am

v2

cyclopic · Answer 6 · 2012-05-09T02:02:00

it's me again..

follow these few steps

1 ) in the design page create a table :

ASP.NET

<table runat="server" id="theTable">

</table>

2 ) in the code behind :

VB

Function GenerateLabel(ByVal pSqlReader As SqlDataReader) As Boolean
        Dim IndexOfLabel As Integer = 1
        Dim tmpTr As New HtmlTableRow
        Dim tmpTd As New HtmlTableCell
        While pSqlReader.Read()
            Dim TmpLabel As New Label
            ' you may not use id if you just display the labels
            TmpLabel.ID = "Label_" & IndexOfLabel.ToString
            TmpLabel.Text = pSqlReader.Item("FieldName").ToString

            tmpTd.Controls.Add(TmpLabel)
            tmpTr.Controls.Add(tmpTd)
            theTable.Controls.Add(TmpTr)
            IndexOfLabel+= 1
        End While
    End Function

3 ) add your try / catch

this code will display a table with as much rows as there are rows in your datatable

Hope helping you

Cyclopic