<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>
SELECT SUM(TotalPrice) AS Total FROM yourTable
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)