【Talk is cheap. Show me the code.】 公众号如有回复不及时的,麻烦点击联系关于我-联系博主,微信我。谢谢!
老帅哥

Stephen-kzx的博客

【Talk is cheap. Show me the code.】【公众号如有回复不及时的,麻烦点击联系关于我-联系博主,微信我。谢谢!】

GridView合并单元格(所有内容相同的单元格)

 源码:

复制代码
1、代码
public static void GroupRow(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;
}
}
}
}
复制代码

 

复制代码
2、代码
//cellNum 表示需要合并的列,索引从0开始
public static void GroupRows(GridView GridView1, int cellNum)
{
int i = 0, 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;
}
}
}
}
复制代码

 

复制代码
3、两张表合并成一张
private DataTable HBTable(DataTable dt1, DataTable dt2)
{
DataTable newDataTable
= dt1.Clone();

object[] obj = new object[newDataTable.Columns.Count];
for (int i = 0; i < dt1.Rows.Count; i++)
{
dt1.Rows[i].ItemArray.CopyTo(obj,
0);
newDataTable.Rows.Add(obj);
}

for (int i = 0; i < dt2.Rows.Count; i++)
{
dt2.Rows[i].ItemArray.CopyTo(obj,
0);
newDataTable.Rows.Add(obj);
}
return newDataTable;


}
复制代码

 

复制代码
4、代码
protected void Unite(GridView gv)
{
int i;
string LastType1;
int LastCell;
if (gv.Rows.Count > 0)
{
for (int j = 0; j < 10; j++)
{
LastType1
= gv.Rows[0].Cells[j].Text;
gv.Rows[
0].Cells[j].RowSpan = 1;
LastCell
= 0;

if (j != 3 && j != 4)
{
for (i = 1; i < gv.Rows.Count; i++)
{
if (gv.Rows[i].Cells[j].Text == LastType1)
{
gv.Rows[i].Cells[j].Visible
= false;
gv.Rows[LastCell].Cells[j].RowSpan
++;
}
else
{
LastType1
= gv.Rows[i].Cells[j].Text;
LastCell
= i;
gv.Rows[i].Cells[j].RowSpan
= 1;
}
}
}
}
}
}
复制代码

复制代码
5、将两张表拼接成一张表
public DataSet MergeTable(DataTable tab1, DataTable tab2)
{
DataTable table
= new DataTable();
if (tab1.Rows.Count != 0 && tab2.Rows.Count != 0)
{
DataColumn[] columns
= new DataColumn[tab1.Columns.Count + tab2.Columns.Count];
tab1.Columns.CopyTo(columns,
0);
tab2.Columns.CopyTo(columns, tab1.Columns.Count);
foreach (DataColumn column in columns)
{
table.Columns.Add(column.ColumnName);
}
int count = tab1.Rows.Count > tab2.Rows.Count ? tab1.Rows.Count : tab2.Rows.Count;
for (int i = 0; i < count; i++)
{
if (tab1.Rows.Count <= i)
{
break;
}
DataRow row
= table.NewRow();
for (int m = 0; m < tab1.Columns.Count; m++)
{
DataRow item
= tab1.Rows[i];
row[tab1.Columns[m].ToString()]
= item[tab1.Columns[m].ToString()];
}
for (int n = 0; n < tab2.Columns.Count; n++)
{
if (tab2.Rows.Count <= i)
{
break;
}
DataRow item
= tab2.Rows[i];
row[tab2.Columns[n].ToString()]
= item[tab2.Columns[n].ToString()];
}
table.Rows.Add(row);
}
}
else
{
table
= tab1.Rows.Count == 0 ? tab2.Copy() : tab1.Copy();
}
DataSet ds
= new DataSet();
ds.Tables.Add(table);
return ds;
}
复制代码

 

 

 

 

posted @   何以解忧唯有撸码  阅读(1809)  评论(0编辑  收藏  举报
编辑推荐:
· 如何编写易于单元测试的代码
· 10年+ .NET Coder 心语,封装的思维:从隐藏、稳定开始理解其本质意义
· .NET Core 中如何实现缓存的预热?
· 从 HTTP 原因短语缺失研究 HTTP/2 和 HTTP/3 的设计差异
· AI与.NET技术实操系列:向量存储与相似性搜索在 .NET 中的实现
阅读排行:
· 周边上新:园子的第一款马克杯温暖上架
· Open-Sora 2.0 重磅开源!
· .NET周刊【3月第1期 2025-03-02】
· 分享 3 个 .NET 开源的文件压缩处理库,助力快速实现文件压缩解压功能!
· [AI/GPT/综述] AI Agent的设计模式综述
点击右上角即可分享
微信分享提示