loop through textbox control at design time

[mamun]

Hi All,
I have the following situation.
I have 10 rows in a form. In each row there are six textbox controls.
The users can enter any number of rows of records (either none or upto
10). I have created these textboxes at design time.

<tr>
<td><asp:TextBo x Width="88px" runat="server" id="txtBore_Num ber1"/></
td>
<td><asp:TextBo x Width="88px" runat="server" id="txtBore_Dat e1"/></td>
<td><asp:TextBo x Width="88px" runat="server" id="txtNorthing 1"/></td>
<td><asp:TextBo x Width="88px" runat="server" id="txtEasting1 "/></td>
<td><asp:TextBo x Width="88px" runat="server" id="txtScale1"/></td>
<td><asp:TextBo x Width="88px" runat="server" id="txtType1"/></td>
</tr>

.......

<tr>
<td><asp:TextBo x Width="88px" runat="server" id="txtBore_Num ber10"/></
td>
<td><asp:TextBo x Width="88px" runat="server" id="txtBore_Dat e10"/></
td>
<td><asp:TextBo x Width="88px" runat="server" id="txtNorthing 10"/></td>
<td><asp:TextBo x Width="88px" runat="server" id="txtEasting1 0"/></td>
<td><asp:TextBo x Width="88px" runat="server" id="txtScale10 "/></td>
<td><asp:TextBo x Width="88px" runat="server" id="txtType10"/></td>
</tr>

I will have to run query for each of the entered rows by Bore Number
and will be inserting into the databases.

How I can check how many rows the users entered data in the bore
number field and write the simple query to insert into table. The
entered data to check by txtBore_Number1 , txtBore_Number2 and so on
upto txtBore_Number1 0.

Thanks a million in advance.

best regards,
mamun