Please help to solve this grid view problem

See more:

ASP.NET

Hello Everyone,

I have a grid view as follows.

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
                   BackColor="White" BorderColor="#999999" BorderStyle="None" BorderWidth="1px"
                   CellPadding="3" DataSourceID="SqlDataSource1" GridLines="Vertical"
                   Width="744px" onselectedindexchanged="GridView1_SelectedIndexChanged"
                   ShowFooter="True" Height="269px">
                   <AlternatingRowStyle BackColor="#DCDCDC" />
                   <Columns>
                       <asp:TemplateField HeaderText="Product" SortExpression="Product">
                           <EditItemTemplate>
                               <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("Product") %>'></asp:TextBox>
                           </EditItemTemplate>
                           <ItemTemplate>
                               <asp:CheckBox ID="CheckBox1" runat="server" />
                               <asp:Label ID="Label1" runat="server" Text='<%# Bind("Product") %>'></asp:Label>
                           </ItemTemplate>
                       </asp:TemplateField>
                       <asp:TemplateField HeaderText="Quantity" FooterText="Total Amount">
                           <FooterTemplate>
                               <asp:Button ID="Button3" runat="server" onclick="Button3_Click"
                                   Text="Total Amount" />
                           </FooterTemplate>
                           <ItemTemplate>
                               <asp:TextBox ID="TextBox2" runat="server" ontextchanged="TextBox2_TextChanged" AutoPostBack="true"></asp:TextBox>
                               <br />
                               <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Style="display: none" />
                               <asp:PlaceHolder ID="PlaceHolder1" runat="server">  </asp:PlaceHolder>
                           </ItemTemplate>
                       </asp:TemplateField>
                       <asp:TemplateField HeaderText="Amount">
                           <FooterTemplate>
                               <asp:Label ID="Label9" runat="server"></asp:Label>
                           </FooterTemplate>
                           <ItemTemplate>
                               <asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>
                           </ItemTemplate>
                       </asp:TemplateField>
                       <asp:TemplateField HeaderText="Status">
                           <ItemTemplate>
                               <asp:DropDownList ID="DropDownList1" runat="server">
                                   <asp:ListItem>New</asp:ListItem>
                                   <asp:ListItem>Refurbished</asp:ListItem>
                               </asp:DropDownList>
                           </ItemTemplate>
                       </asp:TemplateField>
                   </Columns>
                   <FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
                   <HeaderStyle BackColor="Silver" Font-Bold="True" ForeColor="Black" />
                   <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
                   <RowStyle BackColor="#EEEEEE" ForeColor="Black" />
                   <SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
                   <SortedAscendingCellStyle BackColor="#F1F1F1" />
                   <SortedAscendingHeaderStyle BackColor="#0000A9" />
                   <SortedDescendingCellStyle BackColor="#CAC9C9" />
                   <SortedDescendingHeaderStyle BackColor="#000065" />
               </asp:GridView>
               <asp:SqlDataSource ID="SqlDataSource1" runat="server"
                   ConnectionString="<%$ ConnectionStrings:FSPL_AMCConnectionString %>"
                   SelectCommand="SELECT DISTINCT [Product]  FROM [Products]"></asp:SqlDataSource>
               <asp:Button ID="Button2" runat="server" style="font-weight: 700"
                   Text="Add to FSPL Inventory" onclick="Button2_Click" />
           </td>
           <td valign="top">
               <asp:GridView ID="GridView2" runat="server" Height="16px" Width="413px"
                   AutoGenerateColumns="False" BackColor="White" BorderColor="#999999"
                   BorderStyle="Solid" BorderWidth="1px" CellPadding="3" ForeColor="Black"
                   GridLines="Vertical">
                   <AlternatingRowStyle BackColor="#CCCCCC" />
                   <Columns>
                       <asp:TemplateField HeaderText="Invoice Number">
                           <EditItemTemplate>
                               <asp:TextBox ID="TextBox1" runat="server"
                                   Text='<%# Bind("[Invoice Number]") %>'></asp:TextBox>
                           </EditItemTemplate>
                           <ItemTemplate>
                               <asp:ImageButton ID="ImageButton1" runat="server"
                                   ImageUrl="~/images/edit.png" />
                               <asp:Label ID="Label1" runat="server" Text='<%# Bind("[Invoice Number]") %>'></asp:Label>
                           </ItemTemplate>
                       </asp:TemplateField>
                       <asp:TemplateField HeaderText="Date">
                           <EditItemTemplate>
                               <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("Date") %>'></asp:TextBox>
                           </EditItemTemplate>
                           <ItemTemplate>
                               <asp:Label ID="Label2" runat="server" Text='<%# Bind("Date") %>'></asp:Label>
                           </ItemTemplate>
                       </asp:TemplateField>
                       <asp:TemplateField HeaderText="Total Amount">
                           <EditItemTemplate>
                               <asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("[Total Amount]") %>'></asp:TextBox>
                           </EditItemTemplate>
                           <ItemTemplate>
                               <asp:Label ID="Label3" runat="server" Text='<%# Bind("[Total Amount]") %>'></asp:Label>
                           </ItemTemplate>
                       </asp:TemplateField>
                   </Columns>
                   <FooterStyle BackColor="#CCCCCC" />
                   <HeaderStyle BackColor="Silver" Font-Bold="True" ForeColor="Black" />
                   <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
                   <SelectedRowStyle BackColor="#000099" Font-Bold="True" ForeColor="White" />
                   <SortedAscendingCellStyle BackColor="#F1F1F1" />
                   <SortedAscendingHeaderStyle BackColor="#808080" />
                   <SortedDescendingCellStyle BackColor="#CAC9C9" />
                   <SortedDescendingHeaderStyle BackColor="#383838" />
               </asp:GridView>

when i m checking the checkbox and write the number of quantity in quantity textboes then that number of textboes generating dynamically on text changed. when i write the serial no in the dynamic textboxes and insert into the database. In database the correct serial number is not inserting. this my insert code

protected void Button2_Click(object sender, EventArgs e)
    {
        for (int i = 0; i < GridView1.Rows.Count;i++ )
        {
            

            Label lab = (Label)GridView1.Rows[i].FindControl("Label1");
            Label ColTotal = (Label)GridView1.FooterRow.FindControl("Label9");
            TextBox quantity = (TextBox)GridView1.Rows[i].FindControl("TextBox2");
            TextBox TAmount = (TextBox)GridView1.Rows[i].FindControl("TextBox3");
            string amount = quantity.Text;
            DropDownList ddl = (DropDownList)GridView1.Rows[i].FindControl("DropDownList1");

            CheckBox chk = (CheckBox)GridView1.Rows[i].Cells[0].FindControl("Checkbox1");
            if (chk.Checked == true)
            {
                if (quantity.Text != "")
                {



                    for (int j = 0; j < Convert.ToInt16(quantity.Text); j++)
                    {
                        con.Open();

                        string query1 = "insert into Inventory ([Invoice Number],Product,[Serial Number],Amount,Status) values('" + TextBox5.Text + "', '" + lab.Text + "','" + Request.Form["Textbox" + j.ToString().Trim()] + "','" + Convert.ToInt32(TAmount.Text) / Convert.ToInt32(quantity.Text) + "','" + ddl.SelectedValue + "')";
                        SqlCommand cmd = new SqlCommand(query1, con);
                        cmd.ExecuteNonQuery();
                        con.Close();

                    }
                }
                con.Open();
                string query = "insert into FSPL_Inventory ([Invoice Number],[Date],[Total Amount]) values('" + TextBox5.Text + "','" + Label7.Text + "','" + ColTotal.Text + "')";
                SqlCommand comd = new SqlCommand(query, con);
                comd.ExecuteNonQuery();
                con.Close();
                bind();

               

                }









            }
        }

Please help to solve this.