Compare Gridviews

Rajkumar R

HI,

I have 2 gridviews with same columns, but there is a difference in data. Would like to compare 2 gridivews and show the difference data in another gridview or highlight the row

can you please suggest

the below code is highlighting the entire columns for all rows, it should highlight only specific cells which has the difference in data

private void Compare(GridView g1, GridView g2)

{

foreach (GridViewRow row1 in g1.Rows)

{

if (row1.RowType == DataControlRowType.DataRow)

{

string gv1Value = row1.Cells[2].Text;

//iterate second gridview

foreach (GridViewRow row2 in g2.Rows)

{

if (row2.RowType == DataControlRowType.DataRow)

{

string gv2Value = row2.Cells[2].Text;

string gv4Valuke = row2.Cells[1].Text;

//do comparison here

if (gv1Value.Contains(gv2Value))

{

g1.Rows[row1.RowIndex].Cells[2].BackColor = System.Drawing.Color.Blue;

}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ankit Sharma9y ago
just remove the part where it is adding firstdatatable and seconddatatable to resultdatatable.

Just read through code, you will get it.
0
Rajkumar R9y ago
Hi Ankit,

Thanks for sharing the link, it is showing the difference records along with first and second datatable records.

Actually it should show only the difference records
0
Ankit Sharma9y ago
Hi Rajkumar,

you can refer to below link

https://social.msdn.microsoft.com/Forums/en-US/22b905fe-dfb3-4f66-9345-2aeee6050ef1/comparing-two-datagridview-using-c

after comaprison store diffrence in a list and bind it to third GV
0