C# DataGrid合并单元格

小程序：扫一扫查出行
【扫一扫了解最新限行尾号】
复制小程序

1.栏位枚举

private enum DataGridColumn
{
ROWNUM = ,
EMPID,
EMPNAME,
SEX,
SALARY,
ADRRESS,
PHONE,
TEL,
POSITIION,
REMARK
}

2.合并函数

private void SpanRow(DataGrid dg)
{
int i = ;
int j = ;
int rowNum = ;//序号
int rowSpan;
string SEX = ""; //相同SEX，合并SEX单元格
for (i = ; i < dg.Items.Count; i++)
{
rowSpan = ;
SEX = dg.Items[i].Cells[(int)DataGridColumn.SEX].Text;
for (j = i + ; j < dg.Items.Count; j++)
{
if (string.Compare(SEX, dg.Items[j].Cells[(int)DataGridColumn.SEX].Text) == )
{
rowSpan += ;
dg.Items[i].Cells[(int)DataGridColumn.SEX].RowSpan = rowSpan;
dg.Items[j].Cells[(int)DataGridColumn.SEX].Visible = false;
dg.Items[i].Cells[(int)DataGridColumn.EMPNAME].RowSpan = rowSpan;
dg.Items[j].Cells[(int)DataGridColumn.EMPNAME].Visible = false;
dg.Items[i].Cells[(int)DataGridColumn.EMPNAME].RowSpan = rowSpan;
dg.Items[j].Cells[(int)DataGridColumn.EMPNAME].Visible = false;
dg.Items[i].Cells[(int)DataGridColumn.ROWNUM].RowSpan = rowSpan;
dg.Items[j].Cells[(int)DataGridColumn.ROWNUM].Visible = false;
}
else
{
break;
}
}
rowNum = rowNum + ;
dg.Items[i].Cells[(int)DataGridColumn.ROWNUM].Text = System.Convert.ToString(rowNum);
i = j - ;
}
}