ASP.NET (VB) Loop textbox and assign value to each of them

Question

I have 10 textbox in my web page. I have 10 latest records from my database.

How do I loop through the textboxes and assign the database records into them?

Currently I am using hardcode method:

For i = 0 To _datatable.Rows.Count
    If i = 0 Then
        txtbox1.Text = _datatable.Rows(0)("shift").ToString
    ElseIf i = 1 Then
        txtbox2.Text = _datatable.Rows(1)("shift").ToString
    ElseIf i = 2 Then
        txtbox3.Text = _datatable.Rows(2)("shift").ToString
    // and so on...
    End If
Next

so what code have you tried so far?

CurseStacker
– CurseStacker

2017-04-11 04:18:54 +00:00
Commented Apr 11, 2017 at 4:18 — CurseStacker
– CurseStacker, Commented Apr 11, 2017 at 4:18
@CurseStacker Please look at my update

4 Leave Cover
– 4 Leave Cover

2017-04-11 04:27:11 +00:00
Commented Apr 11, 2017 at 4:27 — 4 Leave Cover
– 4 Leave Cover, Commented Apr 11, 2017 at 4:27

CurseStacker · Accepted Answer · 2017-04-11 05:54:56Z

1

Create a Repeater control

<asp:Repeater ID="rptItems" runat="server">
    <ItemTemplate>
        <asp:ID="txtShift" runat="server" Text='<%#Eval("shift") %>' />
    </ItemTemplate>
</asp:Repeater>

<%Eval("shift") %> is what bounds your TextBox to the DataSource. Anything you put inside the <ItemTemplate> will be repeated for each row in your DataTable.

Then on your code behind

rptItems.DataSource = _datatable
rptItems.DataBind()

edited Apr 11, 2017 at 5:54

answered Apr 11, 2017 at 4:32

CurseStacker

1,0898 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Codename Red · Accepted Answer · 2017-04-11 11:51:51Z

0

<asp:Panel ID="pnl1" runat="server">
  <asp:TextBox ID="txt1" runat="server"></asp:TextBox><br />
  <asp:TextBox ID="txt2" runat="server"></asp:TextBox><br />
  <asp:TextBox ID="txt3" runat="server"></asp:TextBox><br />
  <asp:TextBox ID="txt4" runat="server"></asp:TextBox><br />
  <asp:TextBox ID="txt5" runat="server"></asp:TextBox><br />
</asp:Panel>

Code Behind:

For i = 1 To dt.rows.count
  Dim _txt As TextBox = pnl1.FindControl("txt" & i.ToString.Trim)
  Dim _row As String = dt.Rows(i)("column name of your datatable").ToString.Trim
  _txt.Text = _row
Next

dt = datatable - records from sql
hope this code helps.

answered Apr 11, 2017 at 11:51

Codename Red

185 bronze badges

Collectives™ on Stack Overflow

ASP.NET (VB) Loop textbox and assign value to each of them

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related