Hello,
I’ve got this problem when trying to filter data rows in an xceed grid.
The grid is connected to a dataset with 3 tables (a main table, which is displayed in the main grid and 2 secondary tables, displayed in 2 detail grids).
I would like to filter the rows based on information in the main table. So what I tried to do is create a view of the main table and add it a RowFilter, like this :
Private Sub FilterIntoDataGrid(ByVal strSearch As String)
Dim dsSource As Object = Me.DataSource
Dim dtSourceTable As Data.DataTable
Dim dvGenericTable As Data.DataView
dtSourceTable = dsSource.Tables(Me.DataMember)
dvGenericTable = dtSourceTable.DefaultView()
Try
dvGenericTable.RowFilter = strRecherche
Catch ex As Exception
dvGenericTable.RowFilter = String.Empty
End Try
Me.Refresh()
End Sub
The result…nothing. No change in the grid whatsoever, even if the view contains no rows.
Could anyone point me to a solution ? Thank you.
Max
Imported from legacy forums. Posted by AhileCelNegru (had 1973 views)