I want to bind labels from table data.
Question
All replies
-
User-939850651 posted
Hi, priyanka.talekar
You could traverse the query data, dynamically create a label and bind the value.
I create a demo and achieved bind in button click event, you also can do it at other event.
More details, you could refer to the below codes:
FiveLabels.aspx
<body> <form id="form1" runat="server"> <div> <asp:Button runat="server" Text="BindToLabel" OnClick="Bind_Click"/>
<br /> </div> </form> </body>FiveLabels.aspx.cs
protected void Bind_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); String conStr = "data source=.; database=TestDB; integrated security=SSPI"; using (SqlConnection conn = new SqlConnection(conStr)) { String query = "Select time from test"; conn.Open(); using (SqlCommand cmd = new SqlCommand(query, conn)) { SqlDataAdapter sda = new SqlDataAdapter(cmd); sda.Fill(dt); for (int i = 0; i < dt.Rows.Count; i++) { Label label = new Label(); String LabelID = String.Concat("id", (i + 1).ToString()); label.ID = LabelID; label.Text = dt.Rows[i].ItemArray[0].ToString(); label.Width = 100; Page.Controls.Add(label); label = new Label(); LabelID = String.Concat("label", (i+1).ToString()); label.ID = LabelID; label.Text = dt.Rows[i].ItemArray[1].ToString(); Page.Controls.Add(label); Literal literal = new Literal(); literal.Text = "</br>"; Page.Controls.Add(literal); } } } }Result:
When I click the button and its display
Hope this can help you.
Best regards,
Xudong Peng
-
User-939850651 posted
Hi, priyanka.talekar
I create a demo, This may meet your needs?
Please refer to below codes:
aspx.cs
protected void Bind_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); String conStr = "data source=.; database=TestDB; integrated security=SSPI"; using (SqlConnection conn = new SqlConnection(conStr)) { String query = "Select * from test"; conn.Open(); using (SqlCommand cmd = new SqlCommand(query, conn)) { SqlDataAdapter sda = new SqlDataAdapter(cmd); sda.Fill(dt); Page.Form.Controls.Add(new Literal { Text = "</br>"}); for (int i = 0; i < dt.Rows.Count; i++) { Label label = new Label(); String LabelID = String.Concat("label", (i+1).ToString()); label.ID = LabelID; label.Text = dt.Rows[i].ItemArray[1].ToString(); label.Style.Add("text-align", "center"); label.Width = 180; Page.Form.Controls.Add(label); } Literal literal = new Literal(); literal.Text = "</br>"; Page.Form.Controls.Add(literal); for (int i = 0; i < dt.Rows.Count; i++) { TextBox box = new TextBox(); box.AutoPostBack = true; box.Attributes.Add("runat", "server"); box.ID = String.Concat("TextBox", (i + 1).ToString()); box.Style.Add("width", "172px"); box.Text = "TextBox" + (i + 1).ToString(); Page.Form.Controls.Add(box); } } } }Result:
Best regards,
Xudong Peng
-
User-939850651 posted
Hi, Priyanka.talekar
For already designed pages, you can use the FindControl method to get the control and operate it.
More details, you could refer to the below codes:
FiveLabels.aspx <head runat="server"> <title></title> <link href="Content/bootstrap.css" rel="stylesheet" /> </head> <body> <form id="form1" runat="server"> <div> <br /> <asp:Button runat="server" Text="BindToLabel" OnClick="Bind_Click" /> <br /><br /> <div> <div class="col-md-2"> Shift1 - <asp:Label runat="server" ID="Label1"></asp:Label><br /> <asp:TextBox runat="server" ID="TextBox1"></asp:TextBox> </div> <div class="col-md-2"> Shift2 - <asp:Label runat="server" ID="Label2"></asp:Label><br /> <asp:DropDownList runat="server" ID="TextBox2"> <asp:ListItem Text="TextBox2"></asp:ListItem> </asp:DropDownList> </div> <div class="col-md-2"> Shift3 - <asp:Label runat="server" ID="Label3"></asp:Label><br /> <asp:DropDownList runat="server" ID="TextBox3"> <asp:ListItem Text="TextBox3"></asp:ListItem> </asp:DropDownList> </div> <div class="col-md-2"> Shift4 - <asp:Label runat="server" ID="Label4"></asp:Label><br /> <asp:TextBox runat="server" ID="TextBox4"></asp:TextBox> </div> <div class="col-md-2"> Shift5 - <asp:Label runat="server" ID="Label5"></asp:Label><br /> <asp:TextBox runat="server" ID="TextBox5"></asp:TextBox> </div> </div> <br /> </div> </form> </body>FiveLabels.aspx.cs protected void Bind_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); String conStr = "data source=.; database=TestDB; integrated security=SSPI"; using (SqlConnection conn = new SqlConnection(conStr)) { String query = "Select time from test"; conn.Open(); using (SqlCommand cmd = new SqlCommand(query, conn)) { SqlDataAdapter sda = new SqlDataAdapter(cmd); sda.Fill(dt); Page.Form.Controls.Add(new Literal { Text = "</br>"}); for (int i = 0; i < dt.Rows.Count; i++) { //get Label control with control ID, and set value String LabelID = String.Concat("Label",(i+1).ToString()); Label label = (Label)Page.FindControl(LabelID); label.Text = dt.Rows[i].ItemArray[0].ToString(); String TextBoxID = String.Concat("TextBox", (i + 1).ToString()); if (i != 1 && i != 2) { TextBox box = (TextBox)Page.FindControl(TextBoxID); box.Text = "TextBox" + (i + 1).ToString(); } } } } }Result:
Best regards,
Xudong Peng
