problem in merging in gridview cell i want to remove remove dulicate record from cell

See more:

ASP.NET

how to merge cells in asp.net if i have duplicate record in cell
i am using this code but after merging data is showing outside of grid i used paging also
code is here
public class GridDecorator
{
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;
}
}
}
}
}

//Merging cell
protected void gvbenefit_PreRender(object sender, EventArgs e)
{
GridDecorator.MergeRows(gvbenefit);

}


Claim ID



Benefit Type

Diabetic Supplier








--------------------------------------------------------------------------------








Billed Procedures

Claim Number ID

Dos

Procedure Code

Modifier

Units

Bill Amount

Paid Amount



A4253

1234E1231121

1

1

A

1

12000

12000











Sub Total

5

64000

69000











Sub Total

8

52597

53701









Sub Total

8

125476

81478





Sub Total

1

12000

12000