在Gridview中实现合计

在Gridview中实现合计

//gvwOrgDifference为Gridview的ID名。

protected void gvwOrgDifference_RowDataBound(object sender, GridViewRowEventArgs e)
    {
         if (e.Row.RowType == DataControlRowType.Footer)
        {
            TableCell c = e.Row.Cells[0];                                 //定义表的单元格
            c.Controls.Clear();
            c.ColumnSpan = 3;                                             //定义合并跨行的数目
            c.Font.Bold = true;                                           //定义为粗体
            c.HorizontalAlign = HorizontalAlign.Center;                   //定义水平方式
            c.Text = "合 计";                                             //合并单元格内的文字
            e.Row.Cells.RemoveAt(1);                                      //移除第一个单元格
            e.Row.Cells.RemoveAt(2);                                      //移除第二个单元格
            e.Row.Cells.RemoveAt(3);

            e.Row.Cells[1].Text = GetSum(4).ToString();                    //计算第四列的和      
            e.Row.Cells[1].HorizontalAlign = HorizontalAlign.Center;       //设置居中
            e.Row.Cells[2].Text = GetSum(5).ToString();                    //计算第五列的和
            e.Row.Cells[2].HorizontalAlign = HorizontalAlign.Center;       //设置居中
            e.Row.Cells[3].Text = GetSum(6).ToString();                    //计算第六列的和
            e.Row.Cells[3].HorizontalAlign = HorizontalAlign.Center;       //设置居中

          
        }

      
    }

    //定义一个方法。计算列的和
    private int GetSum(int i)
    {
        int sum = 0;
        foreach (GridViewRow row in this.gvwOrgDifference.Rows)
        {
            sum += Convert.ToInt32(row.Cells[i].Text);                  //计算某列的和
        }
        return sum;
    }