Hi, I bound DataSet to DataGridview to display data from SQL DB, I want to change row color to blue, red or write based on row data retrived if the row data meet some condition, any clue?

Thanks,
Martin

This is code to solve your problem

Private Sub dgGrid_RowPrePaint(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewRowPrePaintEventA rgs) Handles dgGrid.RowPrePaint
        Dim tmpCell As New DataGridViewCellStyle()
        tmpCell.BackColor = Color.Beige
        Try
            If GetProperGridCellValue(dgGrid.Item("qty", e.RowIndex), 0) = 1 Then dgGrid.Rows(e.RowIndex).DefaultCellStyle = tmpCell
        Catch

        End Try
    End Sub

Maybe a stupid question, but vs say that GetProperGridCellValue is not declared when it read that code. What is it meant to be dim as ?