Sum of a Column in gridview Footer

Question

4.00/5 (1 vote)

See more:

Hi ,
I am pasting my code here I want to sum of total hours and total minutes in footer of template and i am providing what I have done in aspx.page
If I'm wrong somewhere please let me know and I want to sum of column in footer using compute method.

my aspx code as

XML

<asp:GridView  ID="GvMonthlyAttendance" Width="100%" runat="server" CellPadding="4" ForeColor="#000099"
                    GridLines="None" AutoGenerateColumns="False" Font-Names="Verdana"
                    Font-Size="Small">
                    <AlternatingRowStyle BackColor="White" />
                    <Columns>
                        <asp:BoundField DataField="Date" HeaderText="Date">
                            <ItemStyle HorizontalAlign="Center" />
                        </asp:BoundField>
                        <asp:BoundField DataField="DayOW" HeaderText="Day" />
                        <asp:BoundField DataField="LoginT" HeaderText="Login Time">
                            <ItemStyle HorizontalAlign="Center" />
                        </asp:BoundField>
                        <asp:BoundField DataField="LogouT" HeaderText="Logout Time">
                            <ItemStyle HorizontalAlign="Center" />
                        </asp:BoundField>
                        <asp:TemplateField HeaderText="Hours">
                            <EditItemTemplate>
                                <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("TotalHours") %>'></asp:TextBox>
                            </EditItemTemplate>
                            <FooterTemplate>
                            <asp:Label ID="lblTotalHours" runat="server" ></asp:Label>
                            </FooterTemplate>
                            <ItemTemplate>
                                <asp:Label ID="Label1" runat="server" Text='<%# Bind("TotalHours") %>'></asp:Label>
                            </ItemTemplate>
                            <ItemStyle HorizontalAlign="Center" />
                        </asp:TemplateField>
                        <asp:TemplateField HeaderText="Minutes">
                            <EditItemTemplate>
                                <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("TotalMinutes") %>'></asp:TextBox>
                            </EditItemTemplate>
                            <FooterTemplate>
                            <asp:Label ID="lblTotalMinutes" runat="server" ></asp:Label>
                            </FooterTemplate>
                            <ItemTemplate>
                                <asp:Label ID="Label2" runat="server" Text='<%# Bind("TotalMinutes") %>'></asp:Label>
                            </ItemTemplate>
                            <ItemStyle HorizontalAlign="Center" />
                        </asp:TemplateField>
                    </Columns>
                    <EditRowStyle BackColor="#2461BF" />
                    <EmptyDataTemplate>
                    !!!!! No Record are Found !!!!!
                    </EmptyDataTemplate>
                    <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
                    <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
                    <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
                    <RowStyle BackColor="#EFF3FB" />
                    <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
                </asp:GridView>

and my code behind code is as
below

C#

if (dt.Rows.Count > 0)
            {
                GvMonthlyAttendance.DataSource = dt;
                GvMonthlyAttendance.DataBind();
                ((Label)GvMonthlyAttendance.FooterRow.Cells[4].FindControl("lblTotalHours")).Text = dt.Compute("sum(TotalHours)", "").ToString();
                ((Label)GvMonthlyAttendance.FooterRow.Cells[5].FindControl("lblTotalMinutes")).Text = dt.Compute("sum(lblTotalMinutes)", "").ToString();

}

Question is Solved

Posted 30-Nov-10 20:33pm

Mohd Wasif

Updated 2-Dec-10 22:52pm

Dalek Dave

v3

Add a Solution

Comments

Mohd Wasif 3-Dec-10 4:46am

Question is Solved

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ROGDEV · Answer 1 · 2010-11-30T21:05:00

The way we usually do it, if the grid doesn't have a good sum function (I can't remember if GridView does or not), is to set the cell to an itemtemplate then call a method in the codebehind to stash the value in a dictionary and return the value again. Later in the footer, call a method to return the total value for the column.

Edit here's an example of some c# codebehind code:

C#

public Dictionary<string, decimal> columnTotals;

public decimal saveValue(string colName, decimal cellValue)
{
    columnTotals(colName) += cellValue;
    return cellValue;
}

public decimal getColumnTotal(string colName)
{
    return columnTotals(colName);
}

Then inside your grid call it via:

Data row item template code:

Hours cell: <%# saveValue("totalHours", Eval("TotalHours")).ToString() %>

Mins cell: <%# saveValue("totalMinutes", Eval("Minutes")).ToString() %>

Footer row item template code:

Hours cell: <%# ((int)getColumnTotal("totalHours")).ToString() %>

Mins cell: <%# ((int)getColumnTotal("totalMinutes")).ToString() %>

You can total as many columns as you like without needing to create separate public/global variables for each. Simply pass in unique column names to the saveValue method. We use it for totaling money columns frequently when the grid doesn't support it out of the box.

HTH -rog

TweakBird · Answer 2 · 2010-11-30T21:17:00

Hi Mohd Wasif,

Declare global variables TotalHours, TotalMinutes,

try use following event.

GvMonthlyAttendance_RowDataBound

use this condition for sum of all rows.

if (e.Row.RowType == DataControlRowType.DataRow)
{
Label lblHours= (Label)e.Row.FindControl("lblTotalHours");
            if (lblHours!= null)
            {
                if (lblHours.Text != "")
                    TotalHours+= Convert.ToDouble(lblHours.Text);

}

condition for display in footer

C#

if (e.Row.RowType == DataControlRowType.Footer)
{
e.Row.Cells[4].Text ="Total" +  TotalHours.ToString();
}

same way applicable to TotalMinutes also.

Sum of a Column in gridview Footer

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0