How do I get a total from a GridView and put it elsewhere on the page?

Question

4.00/5 (1 vote)

See more:

I have a web page with several databound GridView controls. In the RowDataBound events for these grids, I accumilate the gross total, like this:

VB

Protected Sub TradesGrid_RowDataBound(ByVal sender As Object, ByVal e As GridViewRowEventArgs)
    If e.Row.RowType = DataControlRowType.DataRow Then
        Dim DVR As DataRowView = CType(e.Row.DataItem, DataRowView)
        If  IsNumeric(DVR("Concession")) Then
            Gross += CDec(DVR("Concession"))
        End If
    End If
End Sub

Once all of the grids have been rendered, I need to put the final gross total at the top of the page, above the grids.

My problem seems to be that the RowDataBound event seems to get fired during the page's render, after my last opportunity to manually change the page's content; even during the PreRenderComplete event, Gross is still zero.

Am I doing something wrong, or will I have to tell management that they can summaries in each grid (which is working fine) but not a full total outside of the grids?

Posted 24-Jun-11 10:12am

Gregory Gadow

Add a Solution

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)

thatraja · Answer 1 · 2011-06-24T17:25:00

Dude, you can try helper functions(in codebehind). You can create another function for All gridview total & call that in codebehind after loading all the gridviews. Try this
How to Display Sum Total in the Footer of the GridView Control[^]

EDIT
--------------------------------------
You can do this way

public partial class _Default : System.Web.UI.Page 
{
    decimal grdTotal1 = 0;//GridView1 Total
    decimal grdTotal1 = 0;//GridView2 Total
    protected void Page_Load(object sender, EventArgs e)
    {
       //After GridView bindings
       lblAllGridViewTotal.Text = (grdTotal1 + grdTotal2).ToString();//Displaying All Total value in a label top of the page
    }
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
 if (e.Row.RowType == DataControlRowType.DataRow)
 {
  decimal rowTotal = Convert.ToDecimal
              (DataBinder.Eval(e.Row.DataItem, "Amount"));
  grdTotal1 = grdTotal1 + rowTotal;//GridView1 Total
 }
 if (e.Row.RowType == DataControlRowType.Footer)
 {
  Label lbl = (Label)e.Row.FindControl("lblTotal");
  lbl.Text = grdTotal1.ToString("c");
 }
}

protected void GridView2_RowDataBound(object sender, GridViewRowEventArgs e)
{
 if (e.Row.RowType == DataControlRowType.DataRow)
 {
  decimal rowTotal = Convert.ToDecimal
              (DataBinder.Eval(e.Row.DataItem, "Amount"));
  grdTotal2 = grdTotal2 + rowTotal;//GridView2 Total
 }
 if (e.Row.RowType == DataControlRowType.Footer)
 {
  Label lbl = (Label)e.Row.FindControl("lblTotal");
  lbl.Text = grdTotal2.ToString("c");
 }
}
}

Running Total In Gridview Footer in ASP.NET C# VB.NET[^]

BTW you just need to change the code little bit(You can store the every summary values in state like session, viewstate, etc., then you can sum all values & you can get the result.). Let me know please.

Abhinav S · Answer 2 · 2011-06-24T18:42:00

Solution 2

Maybe if you use the ItemTemplate to get the total (as shown here[^]), it may help you.

Posted 24-Jun-11 18:42pm

Abhinav S