what a entry for seven days save it in single submit button

Question

hi

 

I am having table for seven days to get data's and save in sql table, in table i want a single submit only...

bt fr save seven days it does nt saving all records, last day records oly saved in sql table.

how to clear the error and save seven day records seperately in sql table by  single submit button .

 

Ex:

 <table>

 

<tr>

<th class="auto-style5">Block01(00.00:00.15)</th>

<td><asp:TextBox ID="txt0" runat="server" size="5" maxlength="4" AutoComplete="off" Width="154px" style="text-align: center"></asp:TextBox></td>

<td><asp:TextBox ID="txt1" runat="server" size="5" maxlength="4" AutoComplete="off" Width="154px" style="text-align: center"></asp:TextBox></td>

<td><asp:TextBox ID="txt2" runat="server" size="5" maxlength="4" AutoComplete="off" Width="154px" style="text-align: center"></asp:TextBox></td>

<td><asp:TextBox ID="txt3" runat="server" size="5" maxlength="4" AutoComplete="off" Width="154px" style="text-align: center"></asp:TextBox></td>

<td><asp:TextBox ID="txt4" runat="server" size="5" maxlength="4" AutoComplete="off" Width="154px" style="text-align: center"></asp:TextBox></td>

<td><asp:TextBox ID="txt5" runat="server" size="5" maxlength="4" AutoComplete="off" Width="154px" style="text-align: center"></asp:TextBox></td>

<td><asp:TextBox ID="txt6" runat="server" size="5" maxlength="4" AutoComplete="off" Width="154px" style="text-align: center"></asp:TextBox></td>

</tr>

<tr>

<th class="auto-style5">Block02(00.15:00.30)</th>

<td><asp:TextBox ID="txt7" runat="server" size="5" maxlength="4" Width="154px" style="text-align: center"></asp:TextBox></td>

<td><asp:TextBox ID="txt8" runat="server" size="5" maxlength="4" Width="154px" style="text-align: center"></asp:TextBox></td>

<td><asp:TextBox ID="txt9" runat="server" size="5" maxlength="4" Width="154px" style="text-align: center"></asp:TextBox></td>

<td><asp:TextBox ID="txt10" runat="server" size="5" maxlength="4" Width="154px" style="text-align: center"></asp:TextBox></td>

<td><asp:TextBox ID="txt11" runat="server" size="5" maxlength="4" Width="154px" style="text-align: center"></asp:TextBox></td>

<td><asp:TextBox ID="txt12" runat="server" size="5" maxlength="4" Width="154px" style="text-align: center"></asp:TextBox></td>

<td><asp:TextBox ID="txt13" runat="server" size="5" maxlength="4" Width="154px" style="text-align: center"></asp:TextBox></td>

</tr>

<tr>

<th class="auto-style5">Block03(00.30:00.45)</th>

<td><asp:TextBox ID="txt14" runat="server" size="5" maxlength="4" style="text-align: center" Width="154px"></asp:TextBox></td>

<td><asp:TextBox ID="txt15" runat="server" size="5" maxlength="4" style="text-align: center" Width="154px"></asp:TextBox></td>

<td><asp:TextBox ID="txt16" runat="server" size="5" maxlength="4" style="text-align: center" Width="154px"></asp:TextBox></td>

<td><asp:TextBox ID="txt17" runat="server" size="5" maxlength="4" style="text-align: center" Width="154px"></asp:TextBox></td>

<td><asp:TextBox ID="txt18" runat="server" size="5" maxlength="4" style="text-align: center" Width="154px"></asp:TextBox></td>

<td><asp:TextBox ID="txt19" runat="server" size="5" maxlength="4" style="text-align: center" Width="154px"></asp:TextBox></td>

<td><asp:TextBox ID="txt20" runat="server" size="5" maxlength="4" style="text-align: center" Width="154px"></asp:TextBox></td>

</tr>

<tr>

<th class="auto-style5">Block04(00.45:01.00)</th>

<td><asp:TextBox ID="txt21" runat="server" size="5" maxlength="4" style="text-align: center" Width="154px"></asp:TextBox></td>

<td><asp:TextBox ID="txt22" runat="server" size="5" maxlength="4" style="text-align: center" Width="154px"></asp:TextBox></td>

<td><asp:TextBox ID="txt23" runat="server" size="5" maxlength="4" style="text-align: center" Width="154px"></asp:TextBox></td>

<td><asp:TextBox ID="txt24" runat="server" size="5" maxlength="4" style="text-align: center" Width="154px"></asp:TextBox></td>

<td><asp:TextBox ID="txt25" runat="server" size="5" maxlength="4" style="text-align: center" Width="154px"></asp:TextBox></td>

<td><asp:TextBox ID="txt26" runat="server" size="5" maxlength="4" style="text-align: center" Width="154px"></asp:TextBox></td>

<td><asp:TextBox ID="txt27" runat="server" size="5" maxlength="4" style="text-align: center" Width="154px"></asp:TextBox></td>

</tr>

<tr>

<th class="auto-style5">Block05(01.00:01.15)</th>

<td><asp:TextBox ID="txt28" runat="server" size="5" maxlength="4" style="text-align: center" Width="154px"></asp:TextBox></td>

<td><asp:TextBox ID="txt29" runat="server" size="5" maxlength="4" style="text-align: center" Width="154px"></asp:TextBox></td>

<td><asp:TextBox ID="txt30" runat="server" size="5" maxlength="4" style="text-align: center" Width="154px"></asp:TextBox></td>

<td><asp:TextBox ID="txt31" runat="server" size="5" maxlength="4" style="text-align: center" Width="154px"></asp:TextBox></td>

<td><asp:TextBox ID="txt32" runat="server" size="5" maxlength="4" style="text-align: center" Width="154px"></asp:TextBox></td>

<td><asp:TextBox ID="txt33" runat="server" size="5" maxlength="4" style="text-align: center" Width="154px"></asp:TextBox></td>

<td><asp:TextBox ID="txt34" runat="server" size="5" maxlength="4" style="text-align: center" Width="154px"></asp:TextBox></td>

</tr>

<tr>

<td class="auto-style21">&nbsp;</td>

<td><asp:Button ID="bts" runat="server" Text="Submit" Height="26px" Width="73px" OnClick="bts_Click" style="font-weight: 700; color: #000099"></asp:Button></td>

<td><asp:Button ID="bts1" runat="server" Text="Submit" Height="26px" Width="73px" OnClick="bts1_Click" style="font-weight: 700; color: #000099"></asp:Button></td>

<td><asp:Button ID="bts2" runat="server" Text="Submit" Height="26px" Width="73px" OnClick="bts2_Click" style="font-weight: 700; color: #000099"></asp:Button></td>

<td><asp:Button ID="bts3" runat="server" Text="Submit" Height="26px" Width="73px" OnClick="bts3_Click" style="font-weight: 700; color: #000099"></asp:Button></td>

<td><asp:Button ID="bts4" runat="server" Text="Submit" Height="26px" Width="73px" OnClick="bts4_Click" style="font-weight: 700; color: #000099"></asp:Button></td>

<td><asp:Button ID="bts5" runat="server" Text="Submit" Height="26px" Width="73px" OnClick="bts5_Click" style="font-weight: 700; color: #000099"></asp:Button></td>

<td><asp:Button ID="bts6" runat="server" Text="Submit" Height="26px" Width="73px" OnClick="bts6_Click" style="font-weight: 700; color: #000099"></asp:Button></td>

</tr>

</table>

 

here having seven submit button fr save seven day records.i need single submit button to do this wrk? hw can do dat?

If there is any other designing method to insert  records in sql table?

 

plz help me