How to bind data to labels programmatically

Hi,

I have some 20 labels in .aspx page, when i run my stored procedure i get datatable filled with two columns and 20 rows (same as the number of labels). The two column names are: 1) ID, 2) Data

Now what I need is, first row "Data" (column in DataTable) value should be displayed as first labels text, second row value should be the second labels text and so on till 20 rows.

Can any one explain me how to do this..

Thanks & regards,

Anand

Re: How to bind data to labels programmatically

ASPX

<asp:PlaceHolder ID="MyPlaceholder" runat="server">
<asp:Label ID="Label1" runat="server" />: <asp:TextBox ID="TextBox1" runat="server" /><br />
<asp:Label ID="Label2" runat="server" />: <asp:TextBox ID="TextBox2" runat="server" /><br />
<asp:Label ID="Label3" runat="server" />: <asp:TextBox ID="TextBox3" runat="server" /><br />
</asp:PlaceHolder>

Code

List<MyData> data = new List<MyData>
{
    new MyData{ID=1, Data="One"},
    new MyData{ID=2, Data="Two"},
    new MyData{ID=3, Data="Three"}
};

Label[] labels = MyPlaceholder.Controls.OfType<Label>().ToArray();

for (int i = 0; i < data.Count; i++)
{
    labels[i].Text = data[i].Data;
}

In the above I'm using a List of this class

    public class MyData
    {
        public int ID { get; set; }
        public string Data { get; set; }
    }

but you just substitute for your own data. The important thing is the OfType command to return all of the labels in a certain container. Once you have that, just iterate your own data and update the corresponding label.

Re: How to bind data to labels programmatically

Thanks for reply,

sample code which you gave works fine, but What I need is, as I told that I have 20 labels with id Label1, Label2, and so on till Label20..

I get DataTable with 20 rows with columns "ID" and "Data", now based on the column "ID", I should bind the "Data" column to label.

for example: if ID=1, then I need to bind "Data" of id = 1 to Label1, If ID=2, label2.Text = <"Data" of id=2> and so on..

Re: How to bind data to labels programmatically

Just use FindControl to dynamically find the corresponding label

foreach (MyData d in data)
{
    Label l = (Label) FindControl("Label" + d.ID.ToString());
    if (l != null)
        l.Text = d.Data;
}

Re: How to bind data to labels programmatically

I get error: Object reference not set to an instance of an object when I am assigning values to existing labels..

Dim i As Integer = 0
            For Each dr As DataRow In DataTableName.Rows
                TryCast(Me.Page.FindControl("Label" & (i + 1)), Label).Text = dr("PTSensoryMotor").ToString()    //The error is thrown here
                i += 1
            Next

Re: How to bind data to labels programmatically

try this

string lbl = ((Label)(this.Page.FindControl(("Label" + (i + 1))))).Text;

then

lbl.text = dr("PTSensoryMotor").ToString()

Re: How to bind data to labels programmatically

Try This code

   public void bindlabel()
   {
       SqlDataAdapter da = new SqlDataAdapter("select * from test1", con);
       DataTable dt = new DataTable();
       da.Fill(dt);
       for (int i = 0; i <= dt.Rows.Count - 1; i++)
       {
           Label lbl = new Label();
           lbl.ID = "lbl" + i;
           lbl.Text = dt.Rows[i][0].ToString();

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


    }

Plz Mark as Answer

Re: How to bind data to labels programmatically

hi,

Your code works fine but, you are creating new labels and adding it form. I don't want to create new labels, I already have labels with id's,

Label1, Label2, Label3, and so on...

Re: How to bind data to labels programmatically

srry anand have you tried my code or not?

Re: How to bind data to labels programmatically

Refer

http://www.aspsnippets.com/Articles/DataBinding-DropDownList-Label-and-Textbox-Controls-in-ASP.Net.aspx

Re: How to bind data to labels programmatically

Yes. But it throwing the same error which i mentioned earlier. Object reference not set to an instance of the object.

string lbl = ((Label)(this.Page.FindControl(("Label" + (i + 1))))).Text; //It throwing error

Re: How to bind data to labels programmatically

can you show me your aspx page please?

Re: How to bind data to labels programmatically

how to post an image of my aspx page??

Re: How to bind data to labels programmatically

Why don't you use any databinding control like Grid or repeater.
You can Use Formview control also for custom layout.

Re: How to bind data to labels programmatically

This is my aspx source...

I don't know whether you can understand..

</div>
            <div style="width:100%">
                <div style="float:left;width:30%;">
                    <asp:Label ID="Label5" runat="server" Text="Label"></asp:Label>
                </div>
                <div style="float:left;">
                    <asp:DropDownList id="ddlWalk300ft" runat="server">
                        <asp:ListItem Text="Verbal/Visual/Model"></asp:ListItem>
                    </asp:DropDownList>
                </div>
                <div class="clear"></div>
            </div>
            <div class="height20"></div>
            <div style="width:100%">
                <div style="float:left;width:30%;">
                    <asp:Label ID="Label6" runat="server" Text="Label"></asp:Label>
                </div>
                <div style="float:left;">
                    <asp:DropDownList id="ddlWalk600ft" runat="server"></asp:DropDownList>
                </div>
                <div class="clear"></div>
            </div>
            <div class="height20"></div>
            <div style="width:100%">
                <div style="float:left;width:30%;">
                    <asp:Label ID="Label7" runat="server" Text="Label"></asp:Label>
                </div>
                <div style="float:left;">
                    <asp:DropDownList id="ddlWalk5minNS" runat="server"></asp:DropDownList>
                </div>
                <div class="clear"></div>
            </div>
            <div class="height20"></div>
            <div style="width:100%">
                <div style="float:left;width:30%;">
                    <asp:Label ID="Label8" runat="server" Text="Label"></asp:Label>
                </div>
                <div style="float:left;">
                    <asp:DropDownList id="ddlWalk10minNS" runat="server"></asp:DropDownList>
                </div>
                <div class="clear"></div>
            </div>
            <div class="height20"></div>
            <div style="width:100%">
                <div style="float:left;width:30%;">
                    <asp:Label ID="Label9" runat="server" Text="Label"></asp:Label>
                </div>
                <div style="float:left;">
                    <asp:DropDownList id="ddlWalk15minNS" runat="server"></asp:DropDownList>
                </div>
                <div class="clear"></div>
            </div>
            <div class="height20"></div>
            <div style="width:100%">
                <div style="float:left;width:30%;">
                    <asp:Label ID="Label10" runat="server" Text="Label"></asp:Label>
                </div>
                <div style="float:left;">
                    <asp:DropDownList id="ddlComp5minER" runat="server"></asp:DropDownList>
                </div>
                <div class="clear"></div>
            </div>
            <div class="height20"></div>
            <div style="width:100%">
                <div style="float:left;width:30%;">
                    <asp:Label ID="Label11" runat="server" Text="Label"></asp:Label>
                </div>
                <div style="float:left;">
                    <asp:DropDownList id="ddlComp10minER" runat="server"></asp:DropDownList>
                </div>
                <div class="clear"></div>
            </div>
            <div class="height20"></div>
            <div style="width:100%">
                <div style="float:left;width:30%;">
                    <asp:Label ID="Label12" runat="server" Text="Label"></asp:Label>
                </div>
                <div style="float:left;">
                    <asp:DropDownList id="ddlComp15minER" runat="server"></asp:DropDownList>
                </div>
                <div class="clear"></div>
            </div>
            <div class="height20"></div>
            <div style="width:100%">
                <div style="float:left;width:30%;">
                    <asp:Label ID="Label13" runat="server" Text="Label"></asp:Label>
                </div>
                <div style="float:left;">
                    <asp:DropDownList id="ddlWalksOnTM" runat="server"></asp:DropDownList>
                </div>
                <div class="clear"></div>
            </div>
            <div class="height20"></div>
            <div style="width:100%">
                <div style="float:left;width:30%;">
                    <asp:Label ID="Label14" runat="server" Text="Label"></asp:Label>
                </div>
                <div style="float:left;">
                    <asp:DropDownList id="ddlPBorSB" runat="server"></asp:DropDownList>
                </div>
                <div class="clear"></div>
            </div>
            <div class="height20"></div>
            <div style="width:100%">
                <div style="float:left;width:30%;">Comments</div>
                <div style="float:left;">
                    <asp:TextBox ID="TextBox6" runat="server" TextMode="MultiLine" Rows="3" Columns="25"></asp:TextBox>
                </div>
                <div class="clear"></div>
            </div>
        </div>
        <div style="float:left; width:47%;">
            <b style="text-decoration:underline;">Transfers</b>
            <div class="height20"></div>
            <div style="width:100%">
                <div style="float:left;width:35%;">
                    <asp:Label ID="Label15" runat="server" Text="Label"></asp:Label>
                </div>
                <div style="float:left;">
                    <asp:DropDownList id="ddlChairtoChair" runat="server">
                        <asp:ListItem Text="Verbal/Visual/Model"></asp:ListItem>
                    </asp:DropDownList>
                </div>
                <div class="clear"></div>
            </div>
            <div class="height20"></div>
            <div style="width:100%">
                <div style="float:left;width:35%;">
                    <asp:Label ID="Label16" runat="server" Text="Label"></asp:Label>
                </div>
                <div style="float:left;">
                    <asp:DropDownList id="ddlSittoStand" runat="server"></asp:DropDownList>
                </div>
                <div class="clear"></div>
            </div>
            <div class="height20"></div>
            <div style="width:100%">
                <div style="float:left;width:35%;">
                    <asp:Label ID="Label17" runat="server" Text="Label"></asp:Label>
                </div>
                <div style="float:left;">
                    <asp:DropDownList id="ddlStandtoSit" runat="server"></asp:DropDownList>
                </div>
                <div class="clear"></div>
            </div>
            <div class="height20"></div>
            <div style="width:100%">
                <div style="float:left;width:35%;">
                    <asp:Label ID="Label18" runat="server" Text="Label"></asp:Label>
                </div>
                <div style="float:left;">
                    <asp:DropDownList id="ddlToilettoChair" runat="server"></asp:DropDownList>
                </div>
                <div class="clear"></div>
            </div>
            <div class="height20"></div>
            <div style="width:100%">
                <div style="float:left;width:35%;">
                    <asp:Label ID="Label19" runat="server" Text="Label"></asp:Label>
                </div>
                <div style="float:left;">
                    <asp:DropDownList id="ddlChairtoToilet" runat="server"></asp:DropDownList>
                </div>
                <div class="clear"></div>
            </div>
            <div class="height20"></div>
            <div style="width:100%">
                <div style="float:left;width:35%;">
                    <asp:Label ID="Label20" runat="server" Text="Label"></asp:Label>
                </div>
                <div style="float:left;">
                    <asp:DropDownList id="ddlStandtoToilet" runat="server"></asp:DropDownList>
                </div>
                <div class="clear"></div>
            </div>
            <div class="height20"></div>
            <div style="width:100%">
                <div style="float:left;width:35%;">
                    <asp:Label ID="Label21" runat="server" Text="Label"></asp:Label>
                </div>
                <div style="float:left;">
                    <asp:DropDownList id="ddlToilettoStand" runat="server"></asp:DropDownList>
                </div>
                <div class="clear"></div>
            </div>
            <div class="height20"></div>
            <div style="width:100%">
                <div style="float:left;width:35%;">
                    <asp:Label ID="Label22" runat="server" Text="Label"></asp:Label>
                </div>
                <div style="float:left;">
                    <asp:DropDownList id="ddlChairtoFloor" runat="server"></asp:DropDownList>
                </div>

Re: How to bind data to labels programmatically

as i can see your labels start from 5 to 22 why are you starting from label1?

Re: How to bind data to labels programmatically

Actually I didn't send full source... If you want I can send all of my source..

Re: How to bind data to labels programmatically

My .aspx page look like below..

Each label has id Label1, Label2, and so on.. Now I need to display text of each label as:

For Label1 - first row (second column) value as Label1.Text,

Label2 - second row (second column value) as Label2.Text and so on from DataTable which has two columns (ID, textData) programmatically.

Re: How to bind data to labels programmatically

if these controls on your form then why are you doing the findcontrol thing

just label1.text = you data

whats your issue?

Re: How to bind data to labels programmatically

Anand Reddy

Each label has id Label1, Label2, and so on.. Now I need to display text of each label as:

For Label1 - first row (second column) value as Label1.Text,

Label2 - second row (second column value) as Label2.Text and so on from DataTable which has two columns (ID, textData) programmatically.

protected void Page_Load(object sender, EventArgs e)
    {
       DataTable table="Your DataTable";
       DataRow[] dr = table.Select("ID>=1"); //Presuming the minimal ID=1,This will select all rows in your DataTable.
       
       int i = 1;
       foreach (GridViewRow row in GridView1.Rows)
       {
           ((Label)row.FindControl("Label"+i)).Text = dr[i-1]["textData"].ToString();
           i++;
       }
    }