GridView 显示数据,在页脚添加合计

  GridView 显示数据,在也脚添加合计

首先设置 ShowFooter为True

 double totalMoney, iMoney;//消费金额
 double totalBZ, iBZ;//补助合计

 protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
     
        if (e.Row.RowType == DataControlRowType.DataRow || e.Row.RowType == DataControlRowType.EmptyDataRow)
        {

            DataRowView drvBasicCountInfor = (DataRowView)e.Row.DataItem;

            iBZ = Convert.ToDouble(drvBasicCountInfor[5]);//补助

            iMoney = Convert.ToDouble(drvBasicCountInfor[4]);//消费金额

            //生成总计

            totalBZ += iBZ;//补助合计

            totalMoney += iMoney;//金额合计

        }

        if (e.Row.RowType == DataControlRowType.Footer)  //页脚
        {

            e.Row.Cells[3].Text = "总计";

           e.Row.Cells[5].Text = string.Format("{0}", totalBZ);

            e.Row.Cells[4].Text = string.Format("{0}", totalMoney);

        }

    }