We help IT Professionals succeed at work.

Highlight asp.net gridview cell from pivot query

I created pivot query to be displayed in a gridview. I'm used Devexpress to create the Gridview and was able to simply use the HtmlDataCellPrepared to show anything that was zeroed out. But now I want to use a row value in the part number column and highlight the adjacent cell under Medium column. I tried to use the RowDataBound but nothing shows up in my query.
Here is a sample of what i'm looking for. If I wanted the Medium cell for only part number ABC-1243 I want that cell highlighted regardless of the value in the size columns
Here's the code that - I have no errors but nothing shows up:
Sub gridStock_RowDataBound(ByVal sender As Object, ByVal e As GridViewRowEventArgs)
        If e.Row.RowType = DataControlRowType.DataRow Then
            If e.Row.Cells(1).Text = "ABC-123" Then
                e.Row.Cells(6).BackColor = System.Drawing.Color.Red
            End If
        End If
    End Sub

Open in new window

Watch Question

Please you try same logic inside of RowCreated event instead of RowDataBound.


Still no difference. I tried all the cell numbers to make sure I was in the correct column. nothing is displaying. grid view is showing but nothing else.
are you sure you are getting correct value in -
e.Row.Cells(1).Text ?

Debug this line check if values of both the sides are coming properly.

Hope this helps you.


I did debug it and there were no errors. I changed the code a little and Now I am getting a "Specified argument was out of the range of valid values. Parameter name: index" error. There error is on line 640:

Line 638:        Dim name As String = e.GetValue("CorePN").ToStr<wbr ></wbr>ing()
Line 639:        If name = "CIT-88D-2015A" Then
Line 640:            e.Row.Cells(10).BackColor = System.Drawing.Color.Red
Line 641:        End If
Line 642:    End Sub

Open in new window

Is there a row check that I have to use?
" out of the range" error is generally comes when you try to access grid row cell (column) by index.
Best practice is access that cell/column by "column_name".
This will never break.

Can you try this:


Thanks again. seemed to work.