如何合计分页GridView全部记录

Question

QUOTE:同意一楼，在数据库查时查出。
--------------------------------
要说"同意竹子"*_*

Answer 1

   private double sum = 0;    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
     if (e.Row.RowIndex >= 0)
        {
            sum += Convert.ToDouble(e.Row.Cells[6].Text.Replace("￥", ""));        }
        else if (e.Row.RowType == DataControlRowType.Footer)
        {
            e.Row.Cells[0].Text = "合计：";
            e.Row.Cells[0].HorizontalAlign = HorizontalAlign.Right;
            e.Row.Cells[1].Text = sum.ToString("C");
            e.Row.Cells[1].HorizontalAlign = HorizontalAlign.Right;
            e.Row.Cells[0].ColumnSpan = 5;
            e.Row.Cells[1].Text = sum.ToString("C")+"(元)";
                } }

Answer 2

 上面是本页的一改ok了.      private double sum = 数据库中取出赋值;
    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
      if (e.Row.RowType == DataControlRowType.Footer)
        {
            e.Row.Cells[0].Text = "合计：";
            e.Row.Cells[0].HorizontalAlign = HorizontalAlign.Right;
            e.Row.Cells[1].Text = sum.ToString("C");
            e.Row.Cells[1].HorizontalAlign = HorizontalAlign.Right;
            e.Row.Cells[0].ColumnSpan = 5;
            e.Row.Cells[1].Text = sum.ToString("C")+"(元)";
                } }