统计合并griview2-优快云博客

本文介绍如何在ASP.NET中使用GridView控件实现数据行的合计功能及合并表脚单元格的方法。通过设置ShowFooter属性，并在RowDataBound事件中统计指定列的数据总和，在RowCreated事件中自定义表脚布局来展示合计信息。

注：将ShowFooter属性设置为true

      int mysum1 = 0;
        Double mysum2 = 0;
        protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
        {
            if (e.Row.RowType == DataControlRowType.DataRow)
            {
                DataRowView myrows = (DataRowView)e.Row.DataItem;

                  //要统计总数的列
                mysum1 += Convert.ToInt32(myrows[8].ToString());
                mysum2 += Convert.ToDouble(myrows[9].ToString());
            }
            // 合计
            //if (e.Row.RowType == DataControlRowType.Footer)
            //{
            //    e.Row.Cells[0].Text = "合计";
            //    e.Row.Cells[8].Text = "总本数:" + mysum1.ToString();
            //    e.Row.Cells[9].Text =mysum2.ToString();
            //}
        }

　　　　//合并单元格

protected void GridView1_RowCreated(object sender, GridViewRowEventArgs e)
{

          //判断是否是表脚
            if (e.Row.RowType == DataControlRowType.Footer)
            {

//获取表脚所在的所有单元格
TableCellCollection TableCell = e.Row.Cells;

              //自动清除表脚
                TableCell.Clear();
                TableCell.Add( new TableHeaderCell() );
                TableCell[0].Text = "合计：";

                TableCell.Add(new TableHeaderCell());
                TableCell[1].ColumnSpan =8;                          //合并行，要和并列是需设置RowSpan ；从第二个单元格一次后合并8个
                TableCell[1].Text = "书本数总计：" + mysum1.ToString()+"本";

                TableCell.Add(new TableHeaderCell());
                TableCell[2].ColumnSpan = 2;
                TableCell[2].Text = "实样总计：" + mysum2.ToString()+"元";
            }
        }

转载于:https://www.cnblogs.com/happygx/archive/2011/02/18/1957932.html