Loading

How to compare two DataGridView Values

Basit Khan

Hi,

I have two DataGridView1 and DataGridView2 which is having same columns and rows.

How to compare between two grids.

I wrote the for loop but no success.

below is the code.

For Each rw1 As DataGridViewRow In DataGridView1.Rows

For Each rw2 As DataGridViewRow In DataGridView2.Rows

If rw1.Cells(3).Value <> rw2.Cells(3).Value Then

If Not rw1.Cells(3).Value Is Nothing Then

rw1.Cells(3).Style.BackColor = Color.Red

End If

Thanks

Basit

2 Replies

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

Gajendra Jangid7y ago
Hi Basit,

please try below code:
for (int i = 0; i < dataGridView1.Rows.count; i++)
{
     for (int j = 0; j < dataGridView2.Rows.count; j++)
     {
   if (dataGridView1.row[i].Cells["ColName"].Value < dataGridView2.row[j].Cells["ColName"].Value)
   {
       dataGridView1.row[i].DataGridViewCellStyle.BackColor = Color.Red;
       dataGridView2.row[j].DataGridViewCellStyle.BackColor = Color.Red;
   }
  }
}
Jignesh Kumar7y ago
H Basit,

Please find below link,
https://stackoverflow.com/questions/22227847/compare-cells-between-two-datagridviews