using footer template the i got the sum of the totals of all records how save the sum into databse table... i m getting sum in gridview not in database table...

<Columns>
    <asp:BoundField DataField="OrderNo" HeaderText="OrderNo" />
    <asp:BoundField DataField="Code" HeaderText="Code" />
    <asp:BoundField DataField="Description" HeaderText="Description" />
    <asp:BoundField DataField="Rate" HeaderText="Rate" />
    <asp:TemplateField HeaderText="Qty">
        <ItemTemplate>
            <asp:Label ID="lblqty" runat="server" Text='<%#Eval("Qty") %>' />
        </ItemTemplate>
        <FooterTemplate>
            <asp:Label ID="lbltxttotalprice" runat="server" Text="TotalPrice" />
        </FooterTemplate>
    </asp:TemplateField>
    <asp:TemplateField HeaderText="Total">
        <ItemTemplate>
            <asp:Label ID="lbltotal" runat="server" Text='<%# Eval("Total") %>' />
        </ItemTemplate>
        <FooterTemplate>
            <asp:TextBox ID="txttotalprice" runat="server" />
        </FooterTemplate>
    </asp:TemplateField>
    <asp:CommandField ShowEditButton="True" />
</Columns>