对gridview的小改动

最新推荐文章于 2022-04-09 17:45:29 发布

weixin_34319374

最新推荐文章于 2022-04-09 17:45:29 发布

阅读量48

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/EddyPeng/archive/2008/06/19/1225883.html

本文介绍了一种在ASP.NET GridView中合并指定列重复数据的方法，并实现了表格底部显示合计行的功能。通过使用C#代码，可以隐藏重复的数据单元格，并设置合并单元格的跨行数。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

///
    /// 合并某列内容相同的行
    ///
    ///
    ///
    public static void GroupRows(GridView GridView1, int cellNum)
    {
        int i = 0;
        int rowSpanNum = 1;

        while (i < GridView1.Rows.Count - 1)
        {
            GridViewRow gvr = GridView1.Rows[i];

            for (++i; i < GridView1.Rows.Count; i++)
            {
                GridViewRow gvrNext = GridView1.Rows[i];

                if (gvr.Cells[cellNum].Text == gvrNext.Cells[cellNum].Text)
                {
                    gvrNext.Cells[cellNum].Visible = false;
                    rowSpanNum++;
                }
                else
                {
                    gvr.Cells[cellNum].RowSpan = rowSpanNum;
                    rowSpanNum = 1;

break;
}

                if (i == GridView1.Rows.Count - 1)
                {
                    gvr.Cells[cellNum].RowSpan = rowSpanNum;
                }
            }
        }
    }

protected void gvMain_DataBound(object sender, EventArgs e)
{
GroupRows(this.gvMain, 1);

}

//加合计行

protected void gvMain_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType != DataControlRowType.Footer && e.Row.RowType != DataControlRowType.Header)
        {
            DataRowView drv = (DataRowView)e.Row.DataItem;

            iNumber = Convert.ToInt32(drv[4]);
            totalNumber += iNumber;
        }
        if (e.Row.RowType == DataControlRowType.Footer)
        {
            e.Row.Cells[4].Text = string.Format("{0}", totalNumber);
            e.Row.Cells[1].Text = "合计";
            e.Row.Cells[3].Visible = false;
            e.Row.Cells[1].ColumnSpan = 2;
            e.Row.Height = 32;
        }
    }

转载于:https://www.cnblogs.com/EddyPeng/archive/2008/06/19/1225883.html