How to calculate sum of item template rowsltaspGridView ID34GRDMonthly34 runat34server34 AutoGenerateColumns34False34 CellPadding34334 FontNames34Georgia34 ForeColor3433333334 GridLines34None34 Width34400px34 CellSpacing34234 onrowdatabound34GRDMonthlyRowDataBound34gt ltAlternatingRowStyle BackColor34White34 gt

Add a ButtonltaspButton ID34btnAddPaidAmount34 runat34server34 OnClick34SumPaidAmount34 Text34Sum Paid Amount34 gtAnd a LabelltaspLabel ID34lblSum34 Text3434 runat34server34 gtAnd the following codeprotected void SumPaidAmountobject sender EventArgs e int sum 0 foreach GridViewRow row1 in GRDMonthlyRows sum intParseTextBoxrow1Cells3FindControl34txtMarks34Text lblSumText sumToString

Calculate Sum of TextBox column in GridView TemplateField on Button click in ASP.Net

leorajen...

SOLVED CLOSED ACTIVE ANSWERED
User: leorajendr
Posted: on Nov 08, 2013 01:54 AM
Forum: Data Controls
Answer: 1
Views: 7366

How to calculate sum of item template rows

<asp:GridView ID="GRDMonthly" runat="server" AutoGenerateColumns="False"
                         CellPadding="3" Font-Names="Georgia" ForeColor="#333333" 
                    GridLines="None" Width="400px" CellSpacing="2" 
                    onrowdatabound="GRDMonthly_RowDataBound">
                         <AlternatingRowStyle BackColor="White" />
                         <Columns>
                             <asp:TemplateField HeaderText="Code">
                                 <ItemTemplate>
                                     <asp:Label ID="lblStudentID" runat="server" Text='<%# Eval("FeeCode") %>' />
                                 </ItemTemplate>
                                 <HeaderStyle Width="90px" />
                                 <ItemStyle Width="10px" />
                             </asp:TemplateField>
                             <asp:TemplateField HeaderText="Fee Name">
                                 <ItemTemplate>
                                     <asp:Label ID="lblStudentName" runat="server" Text='<%# Eval("Fee_Name") %>' />
                                 </ItemTemplate>
                                 <ItemStyle Width="150px" />
                             </asp:TemplateField>
                             <asp:TemplateField HeaderText="Due Amt">
                                 <ItemTemplate>
                                     <asp:Label ID="Label1" runat="server" Text='<%# Bind("DueAmount") %>'></asp:Label>
                                 </ItemTemplate>
                                 <EditItemTemplate>
                                     <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("DueAmount") %>'></asp:TextBox>
                                 </EditItemTemplate>
                                 <ItemStyle Width="100px" />
                             </asp:TemplateField>
                             <asp:TemplateField HeaderText="Paid Amt" FooterStyle-HorizontalAlign="Right">
                                 <ItemTemplate>
                                     <asp:Label ID="lblMarks" runat="server" Text='<%# Eval("PaidAmount") %>' 
                                         Visible="<%# !(bool) IsInEditMode %>" />
                                     <asp:TextBox ID="txtMarks" onkeypress="return onlyNumbers(this);" Width="90px" runat="server" Text='<%# Eval("PaidAmount") %>' 
                                         Visible="<%# IsInEditMode %>" />
                                         <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ErrorMessage="*" ControlToValidate="txtMarks" ValidationGroup="ss"></asp:RequiredFieldValidator>
                                 </ItemTemplate>
                                 
                                 <FooterTemplate>
                    
                </FooterTemplate>
                                 <FooterStyle HorizontalAlign="Right" />
                                 <HeaderStyle Width="90px" />
                             </asp:TemplateField>
                             <asp:TemplateField HeaderText="Previous Balance">
                                 <ItemTemplate>
                                     <asp:Label ID="Label2" runat="server" Text='<%# Bind("Balance") %>'></asp:Label>
                                 </ItemTemplate>
                             </asp:TemplateField>
                         </Columns>
                         <FooterStyle BackColor="#990000" ForeColor="White" Font-Bold="True" />
                         <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
                         <PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />
                         <RowStyle BackColor="#FFFBD6" Font-Names="Verdana" ForeColor="#333333" />
                         <SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />
                         <SortedAscendingCellStyle BackColor="#FDF5AC" />
                         <SortedAscendingHeaderStyle BackColor="#4D0000" />
                         <SortedDescendingCellStyle BackColor="#FCF6C0" />
                         <SortedDescendingHeaderStyle BackColor="#820000" />
                     </asp:GridView>

Mudassar

0 2

Reply
ANSWER
User: Mudassar
Replied: on Nov 08, 2013 05:32 AM
Report

Add a Button

<asp:Button ID="btnAddPaidAmount" runat="server" OnClick="SumPaidAmount" Text="Sum Paid Amount" />

And a Label

<asp:Label ID="lblSum" Text="" runat="server" />

And the following code

protected void SumPaidAmount(object sender, EventArgs e)
    {
        int sum = 0;
        foreach (GridViewRow row1 in GRDMonthly.Rows)
        {
            sum += int.Parse(((TextBox)(row1.Cells[3].FindControl("txtMarks"))).Text);
        }
        lblSum.Text = sum.ToString();
    }

Calculate Sum of TextBox column in GridView TemplateField on Button click in ASP.Net

Company

Explore

Follow us

Contact Us