CODEWITHSUNDEEP
vb.netvisual-studiodatagridview
AlexMagic
AlexMagic

Reputation: 25

DatagridView: Color row based on cell value

I am exposing my problem ... I would like to color the lines of the datagridview taking as reference the value of the column 'LOTTO' until it is the same alternating two colors to facilitate the reading.

enter image description here

as you can see they generally go from 4 to 4 but can vary. for this reason I want to check the 'LOTTO' values

ideas? thanks!!

Upvotes: 0

Views: 485

Answers (1)

Oak_3260548
Oak_3260548

Reputation: 2000

I did this many times, in your case it's using function like this:

Private Sub PaintAccValues()
    Dim Col1 As Color = Color.Beige
    Dim Col2 As Color = Color.Aquamarine
    Dim aCol As Color = Col1

    If Me.dgv.Rows.Count > 0 Then
        Me.dgv.Rows(0).DefaultCellStyle.BackColor = aCol   ' color background of the first row
        Dim RowVal As String = Me.dgv.Rows(0).Cells("Lotto").Value
        For ir = 1 To Me.dgv.Rows.Count - 1  ' notice we're starting on the 2nd line!
            If RowVal = Me.dgv.Rows(ir).Cells("Lotto").Value Then  ' following rows are same
                ' do nothing
            Else ' following rows differ (at the given column 'Lotto')
                If aCol = Col1 Then        ' change colors
                    aCol = Col2
                Else
                    aCol = Col1
                End If
            End If
            Me.dgv.Rows(ir).DefaultCellStyle.BackColor = aCol   ' color a row's background
            RowVal = Me.dgv.Rows(ir).Cells("Lotto").Value       ' set new actual value for a next row comparison
        Next
    End If
End Sub

You would simply call it:

Call PaintAccValues()

in some convenient place, it could be DataBindingComplete(), event for instance.

Obvously, I don't know how your DataGridView is named, or your columns (you didn't provide any code). You can modify it to color only some cells, etc. Or you can add parameters (DataGridViewName and ColumnName or ColumnIndex) and make it work with any DataGridView.

Upvotes: 1

Related Questions