在GridView表VS2010中添加一个GrandTotal页脚-AddaGrandTotalfootertoGridViewtableVS2010

1  

Hi in your gridview do this

嗨，在你的gridview做这个

Now declare like public

现在宣布像公开一样

Private grdTotal As Decimal = 0

After in the event RowDataBound from your gridview

在您的gridview事件中的RowDataBound之后

If e.Row.RowType = DataControlRowType.DataRow Then
    Dim rowTotal As Decimal =
    Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "Amount"))
    grdTotal = grdTotal + rowTotal
End If
If e.Row.RowType = DataControlRowType.Footer Then
    Dim lbl As Label = DirectCast(e.Row.FindControl("lblTotal"), Label)
    lbl.Text = grdTotal.ToString("N2")
End If

1  

If you are adding up just a single column, this should work..

如果你只加一个列，这应该工作..

Code-Behind C#

代码隐藏在C＃

decimal totalA = 0;

protected void gvAlexandria_RowDataBound(object sender, GridViewRowEventArgs e)
{
    string totalAmtFinanced = ((Label)gvVehicleTEMP.FooterRow.FindControl("lblTotalAmtFinanced")).Text;

    if (e.Row.RowType == DataControlRowType.DataRow)
    {        
        totalA += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "AmtFinanced"));
    }
    if (e.Row.RowType == DataControlRowType.Footer)
    {
        //Label lblTotal = (Label)e.Row.FindControl("lblTotal");

        if (totalAmtFinanced != null)
        {                   
            totalAmtFinanced = String.Format("{0:c}", totalA);
        }
    }
}

The column in my gridview that I am adding up is called AmtFinanced. This is how I total up a single column. If you have any problems, let me know!

我加入的gridview中的列称为AmtFinanced。这就是我总共单列的方式。如果您有任何问题，请告诉我！