I have datagridview which is populated with 3 columns partno,locality,houseno. Initially my row colour would be say light blue. Now what i want is whenever houseno changes in row,its row colour should be changed to say grey. That means whenever houseno changes,these two colours should be alternately applied to rows of grid. For example,values that would be populated in houseno column will be 0 0 1 1 2 etc.Now for row with houseno 0 will have row colour as light blue ,for houseno 1 will have row colour grey,for houseno 2 again light blue and so on. Can any1 help me with this. Thanks in advance.
Dim last_value As String = ""
Dim last_color As Color = Color.LightBlue
If DataGridView1.Rows.Count > 0 Then
For Each row In DataGridView1.Rows
If DataGridView1.Item("houseno", row.index).Value <> last_value Then
If last_color = Color.LightBlue Then
DataGridView1.Rows(row.index).DefaultCellStyle.BackColor = Color.LightGray
DataGridView1.Rows(row.index).DefaultCellStyle.BackColor = Color.LightBlue
DataGridView1.Rows(row.index).DefaultCellStyle.BackColor = last_color
If DataGridView1.Rows(row.index).IsNewRow = False Then
last_value = DataGridView1.Item("houseno", row.index).Value.ToString
last_color = DataGridView1.Rows(row.index).DefaultCellStyle.BackColor