datagrid row

I need to change the color of a row when my form loads. I'm using the following code, but it changes the color of all the rows...any suggestions?

VB Code:

Dim i As Integer
        With ds.Tables("checks")
            For i = 0 To .Rows.Count - 1
                If .Rows(i)("check_no") = "2" Then
                    dgView.BackColor = Color.Red
                End If
            Next
        End With

help :(

simple man u just avoid use the for loop

like

With ds.Tables("checks")
If .Rows(i)("check_no") = "2" Then
.row=2
dgView.BackColor = Color.Red
End If
End With
bye

As I said in my response to one of your other posts about this subject, you need to work on your own custom data grid column to allow rows to have different back colours.

In a nutshell, you override the Paint event for the cell as it is painted. If you really really can't work the code out from the other sample then PM me and I'll work something out for you later this evening.

Lil Ms Squirrel, i have done that several times but i could only change the forecolor and backcolor of a total column. i have never got to control a single cell property. why?? because ,

when you override the paint method it is easy to color a column according to it's index ( ordinal no. ) but with specific cells it is very hard as i don't know how much rows are there in the grid nor do i know if the user have arranged them by clicking any column headers. moreover if i have several cells to be painted in different locations. how can i select them without changing the color of the other cells in the grid

that is the question

Thx in advance

RGDS