GridView内表格如何合并，重分求教

想名费脑 2013-03-20 02:22:31

如图表1是正常GridView，表2是想要结果，表格的月份列，月份值为相同时表格合并留一个
求指点
...全文
221 13 打赏 收藏 转发到动态 举报
AI 作业
写回复
用AI写文章
13 条回复
切换为时间正序
请发表友善的回复…
发表回复
wubing1111 2013-03-21
  • 打赏
  • 举报
 回复
网上很多这种例子在这里等答案还不如查一下，自己琢磨呢
想名费脑 2013-03-21
  • 打赏
  • 举报
 回复
[quote=引用 10 楼 a271083650 的回复:] [quote]很有用
是你_不懂 2013-03-20
  • 打赏
  • 举报
 回复
一楼的不错啊，我也试了试，lz解决没，
IssacChow 2013-03-20
  • 打赏
  • 举报
 回复 

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

namespace Echao.WebPage.Class
{
    /// <summary>
    /// 处理前台页面中GridView的合并及相关处理 
    /// </summary>
    public class ycGridView
    {
        /// <summary>
        /// 合并GridView中数据相同的行 只要有相同的都会合并 
        /// </summary>
        /// <param name="gridView"></param>
        public static void MergeRows(GridView gridView)
        {
            for (int rowIndex = gridView.Rows.Count - 2; rowIndex >= 0; rowIndex--)
            {
                GridViewRow row = gridView.Rows[rowIndex];
                GridViewRow previousRow = gridView.Rows[rowIndex + 1];

                for (int i = 0; i < row.Cells.Count; i++)
                {
                    if (row.Cells[i].Text == previousRow.Cells[i].Text)
                    {
                        row.Cells[i].RowSpan = previousRow.Cells[i].RowSpan < 2 ? 2 :
                                               previousRow.Cells[i].RowSpan + 1;
                        previousRow.Cells[i].Visible = false;
                    }
                }
            }
        }

        /// <summary>
        /// 合并GridView中数据指定列的相同行
        /// </summary>
        /// <param name="gridView"></param>
        /// <param name="cellNum"></param>
        public static void GroupRows(GridView gridView, int cellNum)
        {
            try
            {
                int i = 0, rowSpanNum = 1;
                while (i < gridView.Rows.Count - 1)
                {
                    GridViewRow gvr = gridView.Rows[i];
                    for (++i; i < gridView.Rows.Count; i++)
                    {
                        GridViewRow gvrNext = gridView.Rows[i];
                        if (gvr.Cells[cellNum].Text == gvrNext.Cells[cellNum].Text)
                        {
                            gvrNext.Cells[cellNum].Visible = true;
                            rowSpanNum++;
                        }
                        else
                        {
                            gvr.Cells[cellNum].RowSpan = rowSpanNum;
                            rowSpanNum = 1;
                            break;
                        }

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


        #region 合并单元格 合并某一行的所有列
        ///　 <summary>　 
        ///　 合并GridView中某行相同信息的行（单元格） 
        ///　 </summary>　 
        ///　 <param　 name="GridView1">GridView对象</param>　 
        ///　 <param　 name="cellNum">需要合并的行</param> 
        public static void GroupRow(GridView gridView, int rows)
        {
            TableCell oldTc = gridView.Rows[rows].Cells[0];
            for (int i = 1; i < gridView.Rows[rows].Cells.Count; i++)
            {
                TableCell tc = gridView.Rows[rows].Cells[i];　 //Cells[0]就是你要合并的列 
                if (oldTc.Text == tc.Text)
                {
                    tc.Visible = false;
                    if (oldTc.ColumnSpan == 0)
                    {
                        oldTc.ColumnSpan = 1;
                    }
                    oldTc.ColumnSpan++;
                    oldTc.VerticalAlign = VerticalAlign.Middle;
                }
                else
                {
                    oldTc = tc;
                }
            }
        }
        #endregion

        #region 合并单元格 合并一行中的几列
        /// <summary> 
        /// 合并单元格 合并一行中的几列 
        /// </summary> 
        /// <param name="gridView">GridView ID</param> 
        /// <param name="rows">行</param> 
        /// <param name="sCol">开始列</param> 
        /// <param name="eCol">结束列</param> 
        public static void GroupRow(GridView gridView, int rows, int sCol, int eCol)
        {
            TableCell oldTc = gridView.Rows[rows].Cells[sCol];
            for (int i = 1; i < eCol - sCol; i++)
            {
                TableCell tc = gridView.Rows[rows].Cells[i + sCol];　 //Cells[0]就是你要合并的列 
                tc.Visible = false;
                if (oldTc.ColumnSpan == 0)
                {
                    oldTc.ColumnSpan = 1;
                }
                oldTc.ColumnSpan++;
                oldTc.VerticalAlign = VerticalAlign.Middle;
            }
        }
        #endregion

        #region 合并单元格 合并某一列所有行
        /// <summary> 
        /// 合并GridView中某列相同信息的行（单元格） 
        /// </summary> 
        /// <param name="gridView"></param> 
        /// <param name="cellNum"></param> 
        public static void GroupCol(GridView gridView, int cols)
        {
            if (gridView.Rows.Count < 1 || cols > gridView.Rows[0].Cells.Count - 1)
            {
                return;
            }
            TableCell oldTc = gridView.Rows[0].Cells[cols];
            for (int i = 1; i < gridView.Rows.Count; i++)
            {
                TableCell tc = gridView.Rows[i].Cells[cols];
                if (oldTc.Text == tc.Text)
                {
                    tc.Visible = false;
                    if (oldTc.RowSpan == 0)
                    {
                        oldTc.RowSpan = 1;
                    }
                    oldTc.RowSpan++;
                    oldTc.VerticalAlign = VerticalAlign.Middle;
                }
                else
                {
                    oldTc = tc;
                }
            }
        }
        #endregion
        #region 合并单元格 合并某一列中的某些行
        /// <summary> 
        /// 合并单元格 合并某一列中的某些行 
        /// </summary> 
        /// <param name="gridView">GridView ID</param> 
        /// <param name="cellNum">列</param> 
        /// <param name="sRow">开始行</param> 
        /// <param name="eRow">结束列</param> 
        public static void GroupCol(GridView gridView, int cols, int sRow, int eRow)
        {
            if (gridView.Rows.Count < 1 || cols > gridView.Columns.Count - 1)
            {
                return;
            }
            TableCell oldTc = gridView.Rows[sRow].Cells[cols];
            for (int i = 1; i < eRow - sRow; i++)
            {
                TableCell tc = gridView.Rows[sRow + i].Cells[cols];
                tc.Visible = false;
                if (oldTc.RowSpan == 0)
                {
                    oldTc.RowSpan = 1;
                }
                oldTc.RowSpan++;
                oldTc.VerticalAlign = VerticalAlign.Middle;
            }
        }
        #endregion

        /// <summary>
        /// 将gv导出为excel或word
        /// </summary>
        /// <param name="gvName">gv控件名称</param>
        /// <param name="contentType">导出格式Excel:application/ms-excel  Word:application/ms-word</param>
        /// <param name="fileName">导出名称</param>
        public static void ToExcelOrWord(Control gvName, string contentType, string fileName)
        {
            HttpContext.Current.Response.Clear();
            HttpContext.Current.Response.ClearContent();
            HttpContext.Current.Response.ClearHeaders();
            HttpContext.Current.Response.Buffer = true;
            HttpContext.Current.Response.Charset = "GB2312";
            HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpContext.Current.Server.UrlEncode(fileName));
            HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
            HttpContext.Current.Response.ContentType = contentType;

            gvName.Page.EnableViewState = false;
            System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN", true);
            StringWriter stringWriter = new StringWriter(myCItrad);
            HtmlTextWriter htmlWriter = new HtmlTextWriter(stringWriter);

            gvName.RenderControl(htmlWriter);
            HttpContext.Current.Response.Output.Write(stringWriter.ToString());
            HttpContext.Current.Response.Flush();
            HttpContext.Current.Response.End();
        }

    }
}
IssacChow 2013-03-20
  • 打赏
  • 举报
 回复
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI.WebControls; using System.IO; using System.Web.UI; using System.Text; namespace Echao.WebPage.Class { /// <summary> /// 处理前台页面中GridView的合并及相关处理 xcmonline20120304 /// </summary> public class ycGridView { /// <summary> /// 合并GridView中数据相同的行 只要有相同的都会合并 xcmonline20120308 /// </summary> /// <param name="gridView"></param> public static void MergeRows(GridView gridView) { for (int rowIndex = gridView.Rows.Count - 2; rowIndex >= 0; rowIndex--) { GridViewRow row = gridView.Rows[rowIndex]; GridViewRow previousRow = gridView.Rows[rowIndex + 1]; for (int i = 0; i < row.Cells.Count; i++) { if (row.Cells[i].Text == previousRow.Cells[i].Text) { row.Cells[i].RowSpan = previousRow.Cells[i].RowSpan < 2 ? 2 : previousRow.Cells[i].RowSpan + 1; previousRow.Cells[i].Visible = false; } } } } /// <summary> /// 合并GridView中数据指定列的相同行 xcmonline20120314 /// </summary> /// <param name="gridView"></param> /// <param name="cellNum"></param> public static void GroupRows(GridView gridView, int cellNum) { try { int i = 0, rowSpanNum = 1; while (i < gridView.Rows.Count - 1) { GridViewRow gvr = gridView.Rows[i]; for (++i; i < gridView.Rows.Count; i++) { GridViewRow gvrNext = gridView.Rows[i]; if (gvr.Cells[cellNum].Text == gvrNext.Cells[cellNum].Text) { gvrNext.Cells[cellNum].Visible = true; rowSpanNum++; } else { gvr.Cells[cellNum].RowSpan = rowSpanNum; rowSpanNum = 1; break; } if (i == gridView.Rows.Count - 1) { gvr.Cells[cellNum].RowSpan = rowSpanNum; } } } } catch { } } #region 合并单元格 合并某一行的所有列 ///　 <summary>　 ///　 合并GridView中某行相同信息的行（单元格） ///　 </summary>　 ///　 <param　 name="GridView1">GridView对象</param>　 ///　 <param　 name="cellNum">需要合并的行</param> public static void GroupRow(GridView gridView, int rows) { TableCell oldTc = gridView.Rows[rows].Cells[0]; for (int i = 1; i < gridView.Rows[rows].Cells.Count; i++) { TableCell tc = gridView.Rows[rows].Cells[i];　 //Cells[0]就是你要合并的列 if (oldTc.Text == tc.Text) { tc.Visible = false; if (oldTc.ColumnSpan == 0) { oldTc.ColumnSpan = 1; } oldTc.ColumnSpan++; oldTc.VerticalAlign = VerticalAlign.Middle; } else { oldTc = tc; } } } #endregion #region 合并单元格 合并一行中的几列 /// <summary> /// 合并单元格 合并一行中的几列 /// </summary> /// <param name="gridView">GridView ID</param> /// <param name="rows">行</param> /// <param name="sCol">开始列</param> /// <param name="eCol">结束列</param> public static void GroupRow(GridView gridView, int rows, int sCol, int eCol) { TableCell oldTc = gridView.Rows[rows].Cells[sCol]; for (int i = 1; i < eCol - sCol; i++) { TableCell tc = gridView.Rows[rows].Cells[i + sCol];　 //Cells[0]就是你要合并的列 tc.Visible = false; if (oldTc.ColumnSpan == 0) { oldTc.ColumnSpan = 1; } oldTc.ColumnSpan++; oldTc.VerticalAlign = VerticalAlign.Middle; } } #endregion #region 合并单元格 合并某一列所有行 /// <summary> /// 合并GridView中某列相同信息的行（单元格） /// </summary> /// <param name="gridView"></param> /// <param name="cellNum"></param> public static void GroupCol(GridView gridView, int cols) { if (gridView.Rows.Count < 1 || cols > gridView.Rows[0].Cells.Count - 1) { return; } TableCell oldTc = gridView.Rows[0].Cells[cols]; for (int i = 1; i < gridView.Rows.Count; i++) { TableCell tc = gridView.Rows[i].Cells[cols]; if (oldTc.Text == tc.Text) { tc.Visible = false; if (oldTc.RowSpan == 0) { oldTc.RowSpan = 1; } oldTc.RowSpan++; oldTc.VerticalAlign = VerticalAlign.Middle; } else { oldTc = tc; } } } #endregion #region 合并单元格 合并某一列中的某些行 /// <summary> /// 合并单元格 合并某一列中的某些行 /// </summary> /// <param name="gridView">GridView ID</param> /// <param name="cellNum">列</param> /// <param name="sRow">开始行</param> /// <param name="eRow">结束列</param> public static void GroupCol(GridView gridView, int cols, int sRow, int eRow) { if (gridView.Rows.Count < 1 || cols > gridView.Columns.Count - 1) { return; } TableCell oldTc = gridView.Rows[sRow].Cells[cols]; for (int i = 1; i < eRow - sRow; i++) { TableCell tc = gridView.Rows[sRow + i].Cells[cols]; tc.Visible = false; if (oldTc.RowSpan == 0) { oldTc.RowSpan = 1; } oldTc.RowSpan++; oldTc.VerticalAlign = VerticalAlign.Middle; } } #endregion /// <summary> /// 将gv导出为excel或word /// </summary> /// <param name="gvName">gv控件名称</param> /// <param name="contentType">导出格式Excel:application/ms-excel Word:application/ms-word</param> /// <param name="fileName">导出名称</param> public static void ToExcelOrWord(Control gvName, string contentType, string fileName) { HttpContext.Current.Response.Clear(); HttpContext.Current.Response.ClearContent(); HttpContext.Current.Response.ClearHeaders(); HttpContext.Current.Response.Buffer = true; HttpContext.Current.Response.Charset = "GB2312"; HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpContext.Current.Server.UrlEncode(fileName)); HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); HttpContext.Current.Response.ContentType = contentType; gvName.Page.EnableViewState = false; System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN", true); StringWriter stringWriter = new StringWriter(myCItrad); HtmlTextWriter htmlWriter = new HtmlTextWriter(stringWriter); gvName.RenderControl(htmlWriter); HttpContext.Current.Response.Output.Write(stringWriter.ToString()); HttpContext.Current.Response.Flush(); HttpContext.Current.Response.End(); } } }
Dotar 2013-03-20
  • 打赏
  • 举报
 回复
IssacChow 2013-03-20
  • 打赏
  • 举报
 回复
去百度一个gv合并通用类就好了
爱在夕阳下 2013-03-20
  • 打赏
  • 举报
 回复
不要用 asp:GridView 直接后台 生成html代码 前台输出
q107770540 2013-03-20
  • 打赏
  • 举报
 回复
参考： my blog: http://blog.csdn.net/q107770540/article/details/7010526
q107770540 2013-03-20
  • 打赏
  • 举报
 回复 
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Demo.aspx.cs" Inherits="WebApplication1.Demo" %>



<!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>Tim Demo 演示</title>

</head>

<body>

    <form id="form1" runat="server">

    <div>

		<asp:GridView ID="GridView1" runat="server" 

			onrowdatabound="GridView1_RowDataBound">

		</asp:GridView>

    </div>

    </form>

</body>



</html>



using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data;

using System.Drawing;



namespace WebApplication1

{

	public partial class Demo : System.Web.UI.Page

	{

		protected void Page_Load(object sender, EventArgs e)

		{

			if (!IsPostBack)

			{

				BindData();

			}

		}



		void BindData()

		{ 

			var list = new List<Temp>

			{

				new Temp{ SiteName="千灯浦口",Time="2011-9-23",Function=Fun.自动值.ToString(), CODMn="4.10", TOC="6.83",pH="7.10"},

				new Temp{ SiteName="千灯浦口",Time="2011-9-23",Function=Fun.手工值.ToString(), CODMn="4.2", TOC="6.34",pH="7.3"},

				new Temp{ SiteName="千灯浦口",Time="2011-9-23",Function=Fun.偏差.ToString(), CODMn="-2.38%", TOC="7.73%",pH="-2.74%"},

				new Temp{ SiteName="石浦大桥",Time="2011-9-23",Function=Fun.自动值.ToString(), CODMn="3.9", TOC="6.38",pH="7.18"},

				new Temp{ SiteName="石浦大桥",Time="2011-9-23",Function=Fun.手工值.ToString(), CODMn="5.1", TOC="6.08",pH="6.99"},

				new Temp{ SiteName="石浦大桥",Time="2011-9-23",Function=Fun.偏差.ToString(), CODMn="-23.53%", TOC="4.93%",pH="2.72%"},

				new Temp{ SiteName="朱军港口",Time="2011-9-23",Function=Fun.自动值.ToString(), CODMn="3.30", TOC="6.43",pH="6.64"},

				new Temp{ SiteName="朱军港口",Time="2011-9-23",Function=Fun.手工值.ToString(), CODMn="3.5", TOC="5.88",pH="7.02"},

				new Temp{ SiteName="朱军港口",Time="2011-9-23",Function=Fun.偏差.ToString(), CODMn="-5.71%", TOC="9.35%",pH="-5.41%"}

			};

			GridView1.DataSource = list;

			GridView1.DataBind();

		}

		enum Fun

		{

			自动值,

			手工值,

			偏差

		};



		string _tempvalue = "";

		int _temprowspan = 1;

		TableCell _temptablecell = null;

		TableCell _temptablecell2 = null;



		protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)

		{

			if (e.Row.RowType == DataControlRowType.DataRow || e.Row.RowType == DataControlRowType.Footer)

			{

				if (e.Row.Cells[0].Text == _tempvalue)

				{

					_temprowspan++;

					e.Row.Cells.Remove(e.Row.Cells[0]);

					e.Row.Cells.Remove(e.Row.Cells[0]);

				}

				else

				{

					if (_temprowspan != 1)

					{

						_temptablecell.RowSpan = _temprowspan;

						_temptablecell2.RowSpan = _temprowspan;

					}

					_tempvalue = e.Row.Cells[0].Text;

					_temptablecell = e.Row.Cells[0];

					_temptablecell2 = e.Row.Cells[1];

					_temprowspan = 1;

				}

				if (e.Row.Cells[3].Text == "7.3")

				{

					e.Row.Cells[3].BackColor = Color.Red;

				}

			}

		}

	}

	class Temp

	{

		public string SiteName { get; set; }

		public string Time { get; set; }

		public string Function { get; set; }

		public string CODMn { get; set; }

		public string TOC { get; set; }

		public string pH { get; set; }

	}



}



d120759632 2013-03-20
  • 打赏
  • 举报
 回复
GridView里的数据是从数据库里读出来的么？ 从数据库上下工夫撒！
android Gridview分页实现
在Android开发中，GridView是一种常用的布局控件，它允许我们以网格的形式展示数据。当我们处理大量数据时，分页加载可以提高应用性能，减少内存消耗，并提供更好的用户体验。本篇文章将详细讲解如何在Android中利用...
android 通过GridView控件获取本地图片并动态显示 程序源码
文章是参考博客http://blog.csdn.net/eastmount/article/details/41808179完成，主要讲述通过GridView控件点击加号图片动态添加本地相册图片，点击图片可以删除已添加图片。同时界面比较美观。 免费资源，希望对大家...
RecyclerView 瀑布流、ListView、GridView实例源码
在Android开发中，UI界面的展示是至关重要的，RecyclerView、ListView和GridView是常见的列表控件，用于展示大量的数据。本文将深入探讨这三个组件，并通过一个Demo_recyclerview的实例源码来解析它们的工作原理和...
Android可拖拽的GridView,item交换动画效果
Android 可拖拽的GridView，item的实时交互，已经具有交换动画效果，项目详情http://blog.csdn.net/xiaanming/article/details/17718579
Android 可拖拽的GridView效果实现, 长按可拖拽和item实时交换
Android 可拖拽的GridView效果实现, 长按可拖拽和item实时交换，项目详情http://blog.csdn.net/xiaanming/article/details/17718579
.NET社区

62,244

社区成员

668,998

社区内容

发帖
与我相关
我的任务
社区描述
.NET技术交流专区
javascript云原生 企业社区
社区管理员
  • ASP.NET
  • .Net开发者社区
  • R小R
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告

.NET 社区是一个围绕开源 .NET 的开放、热情、创新、包容的技术社区。社区致力于为广大 .NET 爱好者提供一个良好的知识共享、协同互助的 .NET 技术交流环境。我们尊重不同意见，支持健康理性的辩论和互动，反对歧视和攻击。

希望和大家一起共同营造一个活跃、友好的社区氛围。

试试用AI创作助手写篇文章吧

+ 用AI写文章