Roberto Wenzel
Top achievements
Rank 2
Rank 2
Roberto Wenzel
asked on 02 Sep 2008, 03:44 PM
Hello again,
I'm using RadGridView for WinForms Q2. I want to iterate through all cells and highlight text which I am searching for.
I could live with changing the background of the found cell.
The following approch produces errors.
I would be grateful for some help. Cheers Roberto
I'm using RadGridView for WinForms Q2. I want to iterate through all cells and highlight text which I am searching for.
I could live with changing the background of the found cell.
The following approch produces errors.
I would be grateful for some help. Cheers Roberto
Private Sub SearchPhraseInGrid(ByVal searchphrase As String, Optional ByVal colname1 As String = "", Optional ByVal colname2 As String = "")
Dim gv As RadGridView = Me.gvMessages
Dim col As GridViewDataColumn
Dim row As GridViewRowInfo
Dim i As Integer
For Each col In gv.Columns
For Each row In gv.Rows
If (row.Cellscol.FieldName).Value.ToString).Contains(searchphrase) = True Then
i = Me.gvMessages.Rows.IndexOf(Me.gvMessages.CurrentRow)
Me.gvMessages.CurrentRow = Me.gvMessages.Rows(i)
Me.gvMessages.MasterGridViewTemplate.CurrentColumn = Me.gvMessages.Columns(col.Index)
Me.gvMessages.GridElement.CurrentCell.BackColor = Color.Azure
End If
Next
Next
End Sub
1 Answer, 1 is accepted
0
Hello Roberto Wenzel,
Thank you for the question.
I am not quite sure about the errors you are getting. However, it is not recommended to set properties for the appearance of the cells outside the CellFormatting event handler. If you want to set Me.gvMessages.GridElement.CurrentCell.BackColor = Color.Azure in your method, you should first check if CurrentCell is not null, but generally the BackColor property should be set only in the CellFormatting event handler, using e.CellElement which surely is not null.
I have prepared a sample project with a similar to your implementation which demonstrates the correct behavior. Please note that this approach can show only one result (the first or the last), because only one column/row can be current at a time.
My second project implements another approach, which puts a custom back color to all the cells of interest.
If you have additional questions, feel free to contact me.
Best wishes,
Nikolay
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.
Thank you for the question.
I am not quite sure about the errors you are getting. However, it is not recommended to set properties for the appearance of the cells outside the CellFormatting event handler. If you want to set Me.gvMessages.GridElement.CurrentCell.BackColor = Color.Azure in your method, you should first check if CurrentCell is not null, but generally the BackColor property should be set only in the CellFormatting event handler, using e.CellElement which surely is not null.
I have prepared a sample project with a similar to your implementation which demonstrates the correct behavior. Please note that this approach can show only one result (the first or the last), because only one column/row can be current at a time.
My second project implements another approach, which puts a custom back color to all the cells of interest.
If you have additional questions, feel free to contact me.
Best wishes,
Nikolay
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.