第四篇博客：Gridview合并单元格(合并行和列)

最新推荐文章于 2023-03-04 20:23:09 发布
最新推荐文章于 2023-03-04 20:23:09 发布
阅读量9.1k 收藏 14
点赞数 3
分类专栏： C# ASP.NET 文章标签： string asp server object 技术人 class
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/szheroyan/article/details/7101801
版权

           先看效果图： 

            今天研究了一下Gridview合并单元格,自己也试着写了一下,上面是效果图,合并相同的行和相同的列,贴出来给大家分享一下,不足地方希望大家提出来,Demo依然上次资源,希望和大家一起进步.......

     下面看一下我实现的过程吧：

        首先,我写的Demo里面把合并行和合并列(值相同)的方法进行重载,分为模板列和非模板列编辑的两张情况.

        代码如下：

1.GridView合并单元格.aspx 展示页面

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="GridView合并单元格.aspx.cs" Inherits="MyGrvTestPrj._Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>GridView合并单元格</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:GridView ID="GrvInfo" runat="server" AllowPaging="True" GridLines="None"
            AutoGenerateColumns="False" Width="841px" BackColor="White" BorderColor="White" BorderWidth="2px"
            CellPadding="3" CellSpacing="1" ondatabound="GrvInfo_DataBound" BorderStyle="Ridge">
            <Columns>
                <asp:BoundField DataField="StuNo" HeaderText="学生编号" SortExpression="StuNo" />
                <asp:BoundField DataField="StuName" HeaderText="学生姓名" SortExpression="StuName" />
                <asp:BoundField DataField="StuAge" HeaderText="学生年龄" SortExpression="StuAge" />
                <asp:TemplateField HeaderText="学生部门" SortExpression="StuDepartment">
                    <ItemTemplate>
                        <asp:Label ID="lblStuDepartment" runat="server" Text='<%# Eval("StuDepartment") %>'></asp:Label>
                    </ItemTemplate>
                    <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" />
                </asp:TemplateField>
                <asp:TemplateField HeaderText="学生职位" SortExpression="StuManager">
                    <ItemTemplate>
                        <asp:Label ID="lblStuManager" runat="server" Text='<%# Eval("StuManager") %>'></asp:Label>
                    </ItemTemplate>
                    <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" />
                </asp:TemplateField>
                <asp:TemplateField HeaderText="出生地点" SortExpression="StuHome">
                    <ItemTemplate>
                        <asp:Label ID="lblStuHome" runat="server" Text='<%# Eval("StuHome") %>'></asp:Label>
                    </ItemTemplate>
                    <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" />
                </asp:TemplateField>
                <asp:TemplateField HeaderText="居住地点" SortExpression="StuWohnort">
                    <ItemTemplate>
                        <asp:Label ID="lblStuWohnort" runat="server" Text='<%# Eval("StuWohnort") %>'></asp:Label>
                    </ItemTemplate>
                    <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" />
                </asp:TemplateField>
                <asp:TemplateField HeaderText="开始时间--结束时间" SortExpression="StuBeginTime">
                    <ItemTemplate>
                        <asp:Label ID="lblStuTime" runat="server" Text='<%#GetTotal(Eval("StuBeginTime"),Eval("StuEndTime")) %>'></asp:Label>
                        <!--<asp:Label ID="lblStuTime1" runat="server" Text='<%#string.Format("{0}--{1}",Eval("StuBeginTime"),Eval("StuEndTime")) %>'></asp:Label>-->
                    </ItemTemplate>
                    <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" />
                </asp:TemplateField>
            </Columns>
            <RowStyle BackColor="#DEDFDE" ForeColor="Black" HorizontalAlign="Center"
                BorderStyle="Solid" BorderColor="Black" BorderWidth="2px" />
            <FooterStyle BackColor="#C6C3C6" ForeColor="Black" />
            <PagerStyle ForeColor="Black" HorizontalAlign="Right" BackColor="#C6C3C6" />
            <SelectedRowStyle BackColor="#9471DE" Font-Bold="True" ForeColor="White" />
            <HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#E7E7FF" />
        </asp:GridView>
    </div>
    </form>
</body>
</html>

2.GridView合并单元格.aspx.cs 后台操作代码

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace MyGrvTestPrj
{
    public partial class _Default : System.Web.UI.Page
    {
        #region Attribute

 

        #endregion

        #region Page_Load

        /// <summary>
        /// 页面加载事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void Page_Load(object sender, EventArgs e)
        {
            if(!IsPostBack)
            {
                this.GrvInfo.DataSource = new List<StuInfo>()
                {
                        new StuInfo(){StuNo="Stu001",StuName="张三",StuAge=18,StuDepartment="网络部",StuManager="主管",StuHome="江苏宿迁",StuWohnort="江苏苏州",StuBeginTime="2011-01-01",StuEndTime="2011-02-28"},
                        new StuInfo(){StuNo="Stu002",StuName="李四",StuAge=19,StuDepartment="网络部",StuManager="技术人员",StuHome="江苏宿迁",StuWohnort="江苏宿迁",StuBeginTime="2011-03-01",StuEndTime="2011-04-30"},
                        new StuInfo(){StuNo="Stu003",StuName="王五",StuAge=20,StuDepartment="网络部",StuManager="技术人员",StuHome="江苏宿迁",StuWohnort="江苏宿迁",StuBeginTime="2011-05-01",StuEndTime="2011-06-30"},
                        new StuInfo(){StuNo="Stu004",StuName="赵六",StuAge=21,StuDepartment="销售部",StuManager="主管",StuHome="江苏南京",StuWohnort="江苏苏州",StuBeginTime="2011-07-01",StuEndTime="2011-08-31"},
                        new StuInfo(){StuNo="Stu005",StuName="钱七",StuAge=22,StuDepartment="销售部",StuManager="销售人员",StuHome="江苏南京",StuWohnort="江苏南京",StuBeginTime="2011-09-01",StuEndTime="2011-10-31"},
                        new StuInfo(){StuNo="Stu006",StuName="王八",StuAge=23,StuDepartment="销售部",StuManager="销售人员",StuHome="江苏南京",StuWohnort="江苏南京",StuBeginTime="2011-11-01",StuEndTime="2011-12-31"},
                };
                this.GrvInfo.DataBind();
            }
        }

        #endregion

        #region Function

        /// <summary>
        /// 拼接字符串(显示的字符串日期)
        /// </summary>
        /// <param name="obj1"></param>
        /// <param name="obj2"></param>
        /// <returns></returns>
        protected string GetTotal(object obj1, object obj2)
        {
            return obj1.ToString() + "--" + obj2.ToString();
        }

        #endregion

        #region Event

        /// <summary>
        /// 控件被数据绑定后触发()
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void GrvInfo_DataBound(object sender, EventArgs e)
        {
            //合并行
            CommonClass.UnitRow(GrvInfo, 3, "lblStuDepartment");
            CommonClass.UnitRow(GrvInfo, 4, "lblStuManager");
            //合并列
            CommonClass.UnitCell(GrvInfo, 5, "lblStuHome", "lblStuWohnort");           
        }

        #endregion
    }
}

3.CommonClass.cs 公共调用的类

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI.WebControls;

namespace MyGrvTestPrj
{
    /// <summary>
    /// 公共类合并Grv单元格
    /// </summary>
    public class CommonClass
    {
        #region 合并行(相同值)-普通列

        /// <summary>
        /// 合并行(普通列)
        /// </summary>
        /// <param name=“gv”>所对应的GridView对象</param>
        /// <param name=“columnIndex”>所对应要合并的列的索引</param>
        public static void UnitRow(GridView gv, int columnIndex)
        {
            int i;
            string lastType;
            int lastCell;
            if (gv.Rows.Count > 0)
            {
                lastType = gv.Rows[0].Cells[columnIndex].Text;
                gv.Rows[0].Cells[columnIndex].RowSpan = 1;
                lastCell = 0;
                for (i = 1; i < gv.Rows.Count; i++)
                {
                    if (gv.Rows[i].Cells[columnIndex].Text == lastType)
                    {
                        gv.Rows[i].Cells[columnIndex].Visible = false;
                        gv.Rows[lastCell].Cells[columnIndex].RowSpan++;
                    }
                    else
                    {
                        lastType = gv.Rows[i].Cells[columnIndex].Text;
                        lastCell = i;
                        gv.Rows[i].Cells[columnIndex].RowSpan = 1;
                    }
                }
            }
        }

        #endregion

        #region 合并行(相同值)-模板列

        /// <summary>
        /// 合并行(模板列)
        /// </summary>
        /// <param name=“gv”>所对应的GridView对象</param>
        /// <param name=“columnIndex”>所对应要合并的列的索引</param>  
        /// <param name=“lblName”>模板列里面Lable的Id</param>
        public static void UnitRow(GridView gv, int columnIndex, string lblName)
        {
            int i;
            string lastType;
            int lastCell;
            if (gv.Rows.Count > 0)
            {
                lastType = (gv.Rows[0].Cells[columnIndex].FindControl(lblName) as Label).Text;
                gv.Rows[0].Cells[columnIndex].RowSpan = 1;
                lastCell = 0;
                for (i = 1; i < gv.Rows.Count; i++)
                {
                    if ((gv.Rows[i].Cells[columnIndex].FindControl(lblName) as Label).Text == lastType)
                    {
                        gv.Rows[i].Cells[columnIndex].Visible = false;
                        gv.Rows[lastCell].Cells[columnIndex].RowSpan++;
                    }
                    else
                    {
                        lastType = (gv.Rows[i].Cells[columnIndex].FindControl(lblName) as Label).Text;
                        lastCell = i;
                        gv.Rows[i].Cells[columnIndex].RowSpan = 1;
                    }
                }
            }
        }

        #endregion

        #region 合并列(相同值)-普通列

        /// <summary>
        /// 合并列(普通列)
        /// </summary>
        /// <param name="gv">所对应的GridView对象</param>
        /// <param name="columnIndex">所对应要合并的列的索引</param>
        public static void UnitCell(GridView gv,int columnIndex)
        {
            int i;
            string lastType;
            if (gv.Rows.Count > 0)
            {               
                for (i = 1; i < gv.Rows.Count; i++)
                {
                    lastType = gv.Rows[i].Cells[columnIndex].Text;
                    gv.Rows[i].Cells[columnIndex].ColumnSpan = 1;
                    if (gv.Rows[i].Cells[columnIndex+1].Text == lastType)
                    {
                        gv.Rows[i].Cells[columnIndex+1].Visible = false;
                        gv.Rows[i].Cells[columnIndex].ColumnSpan++;
                    }
                    else
                    {
                        lastType = gv.Rows[i].Cells[columnIndex].Text;
                        gv.Rows[i].Cells[columnIndex].ColumnSpan = 1;
                    }
                }
            }
        }

        #endregion

        #region 合并列(相同值)-模板列

        /// <summary>
        /// 合并行(模板列)
        /// </summary>
        /// <param name=“gv”>所对应的GridView对象</param>
        /// <param name=“columnIndex”>所对应要合并的列的索引</param>  
        /// <param name=“lblName1”>模板列里面Lable1的Id</param>
        /// /// <param name=“lblName1”>模板列里面Lable2的Id</param>
        public static void UnitCell(GridView gv, int columnIndex, string lblName1,string lblName2)
        {
            int i;
            string lastType;
            if (gv.Rows.Count > 0)
            {               
                for (i = 0; i < gv.Rows.Count; i++)
                {
                    lastType = (gv.Rows[i].Cells[columnIndex].FindControl(lblName1) as Label).Text;
                    gv.Rows[i].Cells[columnIndex].ColumnSpan = 1;
                    if ((gv.Rows[i].Cells[columnIndex + 1].FindControl(lblName2) as Label).Text == lastType)
                    {
                        gv.Rows[i].Cells[columnIndex+1].Visible = false;
                        gv.Rows[i].Cells[columnIndex].ColumnSpan++;
                    }
                    else
                    {
                        lastType = (gv.Rows[i].Cells[columnIndex].FindControl(lblName1) as Label).Text;
                        gv.Rows[i].Cells[columnIndex].ColumnSpan = 1;
                    }                   
                }
            }
        }

        #endregion
    }
}
4.StuInfo.cs 学生信息类

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace MyGrvTestPrj
{
    /// <summary>
    /// 测试数据类
    /// </summary>
    public class StuInfo
    {
        /// <summary>
        /// 学生编号
        /// </summary>
        public string StuNo { set; get; }
        /// <summary>
        /// 学生姓名
        /// </summary>
        public string StuName { set; get; }
        /// <summary>
        /// 学生年龄
        /// </summary>
        public int StuAge { set; get; }
        /// <summary>
        /// 学生部门
        /// </summary>
        public string StuDepartment { set; get; }
        /// <summary>
        /// 学生职位
        /// </summary>
        public string StuManager { set; get; }
        /// <summary>
        /// 出生地
        /// </summary>
        public string StuHome { set; get; }
        /// <summary>
        /// 居住地
        /// </summary>
        public string StuWohnort { set; get; }
        /// <summary>
        /// 开始时间
        /// </summary>
        public string StuBeginTime { set; get; }
        /// <summary>
        /// 结束时间
        /// </summary>
        public string StuEndTime { set; get; }
    }
}

      以上就是我实现的方法,封装好了,可以直接使用,有不足的地方还希望大家能够指出,继续改进,做得更好, 以求不断的进步,O(∩_∩)O谢谢......圣诞快乐,祝大家生活工作愉快!!!!

 

szheroyan
关注
  • 3
    点赞
  • 踩
  • 14
    收藏
    觉得还不错? 一键收藏
  • 2
    评论
专栏目录
GridView合并单元格
11-13
GridView合并单元格,引合并单元格,实际上是合并数据结构.然后把处理后的数据绑定到GridView控件中.
怎么把GridView表格合并行
m0_64244048的博客
03-28 1080
Grid View
GridView多行多列合并单元格（完整代码和例子）
weixin_34268753的博客
10-10 494
GitHub项目地址：https://github.com/mingceng/merge-gridviewcell 使用GridView展示数据，经常会遇到合并单元格的情况。首先说明一下项目中合并单元格的要求,如下图所示，左边是合并之前的GridView，右边是合并之后的GridView。从图中可以看到GridView一共有“等级”、“颜色”，“箱子”，“净重”，“规格”，“汇总”6列，首先要要...
GridView 合并列、行类
weixin_30367169的博客
09-16 192
using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Data;using System.Web.UI.WebControls; /// <summary>///GridViewMergeCell 合并GridView liyang 20090916/...
wpf GridView 合并单元格 Demo
06-20
在Windows Presentation Foundation (WPF) 中，GridView 是DataGrid控件的一种视图模式，它用于显示数据集合，并且常用于创建表格布局。...希望这个教程对你理解和使用WPF GridView的单元格合并有所帮助。
横向合并单元格.zip
08-12
1. GridControl的合并单元格功能允许用户在显示数据时合并相邻的列，从而提高数据的可读性和美观度。在DevExpress中，我们可以通过设置`ColumnBand`或`RowBand`对象的`MergeWith`属性来实现这一功能。例如，如果你有...
博客中的Gridview合并单元格
12-25
合并单元格通常指的是将多个相邻的行或列的单元格合并为一个大的单元格，这样可以在视觉上创建出更清晰、更有组织的布局。在ASP.NET的GridView中，这可以通过编程方式或者通过模板字段来实现。 1. **编程方式合并...
DevExpress GridControl中合并单元格
02-16
在DevExpress的GridControl中，合并单元格是一种常见的需求，它能帮助我们更好地组织和展示数据。GridControl提供了多种方法来实现单元格的合并，这些方法适用于不同的场景和需求。以下将详细阐述如何在DevExpress ...
GridView实现多表头合并
06-05
4. **合并单元格**：在后台代码中，通过遍历HeaderRow的Cells，根据数据源的层级关系，调用`TableCell`的`MergeCells()`方法进行合并。注意，合并时需要考虑同一列中的所有行。 5. **处理数据行**：根据数据源，为...
Dev GridView Winform 横竖合并单元格
功夫再高也怕菜刀 充分体现了科技的力量
02-06 4210
参考：http://bbs.csdn.net/topics/390692607源码下载地址：下载以下源码：待合并单元格对象using System;using System.Collections.Generic;using System.Linq;using System.Text;using DevExpress.XtraGrid.Columns;namespace MyUtil{ pu
C#开发学习笔记:GridView设置数据相同的列合并
JustWantToFly的博客
01-02 1404
using DevExpress.XtraGrid.Views.Grid; using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using...
GridView相关技术(六--合并相同数据单元格)
chenxueyong
09-26 212
大家GridView都用的比较多吧..   有没遇到单元格需要合并的需求.. 单元格合并原理其实很简单，就是逐行判断要合并的单元格里的值是否和上一行的相同，要是相同的话就合并，不同的话就接着判断 我们可以通过扩展方法为GridView添加单元合并  public static class GridViewExtensions    {        /// &lt;summary&gt; ...
gridview 合并列
haibin_hu的专栏
08-16 602
//从grd的第rowIndex行colIndex列单元格向右count列合并 public static void 合并列(this GridView grd, int rowIndex, int colIndex, int count) { grd.Rows[rowIndex].Cells[colIndex].ColumnSpan = count;
C# 合并单元格
weixin_44679229的博客
09-04 1497
gridview事件CellMerge 单元格合并 合并列 //合并(在查询中开启 bandedGridView1.OptionsView.AllowCellMerge = true;) private void gridView1_CellMerge(object sender, CellMergeEventArgs e) { int rowHandle1 = e.RowHandle1; int rowHa
GridView 单元格的合并
song_better的专栏
11-25 409
        今天用到GridView合并单元格,在网上找了些资料,为方便以后资料查找,特记录如下:         private void MergeCells()    {        if (gvStock.Rows.Count         {            return;        }        for (int i =
dev GridControl 按条件纵向合并单元格
wushijun5200的博客
03-04 1594
dev GridControl 按条件纵向合并单元格。
wpf gridview 合并行
最新发布
07-22
通过调整Grid控件的行和列的合并方式以及合并的单元格范围，我们可以将多行合并为一行。 最后，我们还可以使用第三方的扩展库来实现行合并的功能。例如，可以使用Syncfusion公司的WPF控件库中的GridGroupingControl...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 2
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值