Search a gridview and change the item color if found in a query result

naveenkohli,

Thanks - I will see if I can decode the C# into vb and let you know.

It should be possible using the OnRowDataBound event of the gridview.  I didn't check that link naveenkohli gave, but I can assist if you are going to do it this way.  In VB too...

The link gives you the idea on how to modify behavior in OnRowCreated event. you should be able to wrie your own solution in VB.Net on similar lines. If you run into any issue feel free to let me know. I can try to wing some VB code :-)

Thanks both, I found a site that converted the C# to VB. What it provided is listed below:
----------------------------------------------------------------------------------
    Protected Sub OnRowCreated(ByVal sender As Object, ByVal e As GridViewRowEventArgs)
        If e.Row.RowType = DataControlRowType.DataRow Then
            Dim drv As Data.DataRowView = TryCast(e.Row.DataItem, Data.DataRowView)
            Dim ob As Object = drv("Weight")
            If Not Convert.IsDBNull(ob) Then
                Dim dVal As Double = 0.0F
                If [Double].TryParse(ob.ToString(), dVal) Then
                    If dVal > 3.0F Then
                        Dim cell As TableCell = e.Row.Cells(1)
                        cell.CssClass = "heavyrow"
                        cell.BackColor = System.Drawing.Color.Orange
                    End If
                End If
            End If
        End If
    End Sub
----------------------------------------------------------------------------------
What I needed is code which will allow me to search each gridview and compare to the returned values provided by the SQL query. Then if a match is made it will change the background color. In the sample provided by the link it looks like it is looking for a hard coded value.

I would suggest, perhaps, a query to your db in the page load and set this as a dataset.  You should be able to reference this dataset outside of that sub if you declare it in the class itself, rather than in the sub.  Then, in your OnRowCreated sub, you can cycle through the dataset for each row/cell that you want and perform your highlighting then.

Does that make sense?

I am hitting a wall.....
In the example I provided how would I search for, say,  'MNO' which resides under the SHELF2 gridview?
In this example I want to search through all of the rows in SHELF2 and when I find the cell or row that contains 'MNO' do something with it.
If you could provide code it would help......