Hello,
I have a DataGridView on my form that is populated with data from a website table.
Now I would like to be able to search for a specific String or Value in the 'entire' grid.
When the String is found, I would like to get the index of the row it was found on.
I've tried several methods, none of them seem to work, I always get the error Object is not an instance...
Like this piece of code below which should paint the cell of the searched string - that I've put into tb1 - yellow, but each time I get the same error.
In this case the error is on the following line:Code:Dim searchedText As String = tb1.Text Dim gridRow As Integer = 0 Dim gridColumn As Integer = 0 For Each Row As DataGridViewRow In dgv.Rows For Each column As DataGridViewColumn In dgv.Columns Dim cell As DataGridViewCell = (dgv.Rows(gridRow).Cells(gridColumn)) If cell.Value.ToString.Contains(searchedText) Then cell.Style.BackColor = Color.Yellow End If gridColumn += 1 Next column gridColumn = 0 gridRow += 1 Next Row
If cell.Value.ToString.Contains(searchedText) Then
Object reference not set to an instance of an object.
I even tried like every code snippet I could find, modified them to my needs, but I keep getting the same error.
Is there anything I did wrong with my DataGridView?


Reply With Quote
