Qty footer control remains empty despite assigning a value to it
please help
<asp:GridView ID="Gvgridclient" runat="server" AutoGenerateColumns="False" ShowFooter="True">
<Columns>
<asp:BoundField DataField="itemcode" HeaderText="Itemcode" />
<asp:BoundField DataField="stockitem" HeaderText="Item Description" />
<asp:BoundField DataField="itemsize" HeaderText="itemsize" />
<asp:TemplateField HeaderText="Qty">
<EditItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("Qty") %>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="Fqty" runat="server" Width="46px"></asp:TextBox>
</FooterTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Bind("Qty") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="saleprice" HeaderText="OrderPrice" />
<asp:BoundField DataField="saleprice" HeaderText="SalePrice" />
<asp:BoundField HeaderText="Subtotal" />
<asp:BoundField DataField="account" HeaderText="Admno" />
<asp:BoundField DataField="clientname" HeaderText="Names" />
</Columns>
</asp:GridView>
Private Sub BindGrid()
' Dim query As String = "SELECT TOP 30 OrderID,"
' query += "(SELECT ProductName FROM Products WHERE ProductID = details.ProductId) ProductName,"
' query += "(Quantity * UnitPrice) Price"
' query += " FROM [Order Details] details"
' query += " ORDER BY OrderID"
Dim query As String = "SELECT invno, date, qty, orderprice, subtotal, ordervat, subtotal2, orderuser, ordertime, scancode, shift, itemcostprice, poststatus, stockitem, saleprice, itemcode, saleunit, saletype, hidesale, noitemscarton, batchno, expirydate, batch,
account, clientname, salesperson, keyfield, itemsize FROM ordersubformhidesales where account='" & Account.Text & "'"
Dim constr As String = ConfigurationManager.ConnectionStrings("UNIFORMConnectionString").ConnectionString
Using con As New SqlConnection(constr)
Using cmd As New SqlCommand(query)
Using sda As New SqlDataAdapter()
cmd.Connection = con
sda.SelectCommand = cmd
Using dt As New DataTable()
sda.Fill(dt)
Gvgridclient.DataSource = dt
Gvgridclient.DataBind()
Dim total As Integer = dt.AsEnumerable().Sum(Function(row) row.Field(Of Integer)("Qty"))
Gvgridclient.FooterRow.Cells(1).Text = "Total"
Gvgridclient.FooterRow.Cells(1).HorizontalAlign = HorizontalAlign.Right
Gvgridclient.FooterRow.Cells(2).Text = total.ToString("N2")
DirectCast(Gvgridclient.FooterRow.FindControl("Fqty"), TextBox).Text = total
End Using
End Using
End Using
End Using