This piece of code will do a 'contains' filter on a Janus grid
Private Sub txtFilter_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs)
Dim txtSubdivisionName As GridEXColumn
'Get a reference of the column to be compared
txtSubdivisionName = GridEX1.RootTable.Columns("vchrSubdivisionName")
Dim intOperator As Janus.Windows.GridEX.ConditionOperator = ConditionOperator.Contains
'Create the condition
Dim condition As New GridEXFilterCondition(txtSubdivisionName, intOperator, Me.txtFilter.Text)
'Assign the condition to the table to filter the records
GridEX1.RootTable.FilterCondition = condition
End Sub
This code will allow multiple filter conditions
Private Sub filter()
Dim colBidderNo As GridEXColumn
Dim colCompany1 As GridEXColumn
Dim strBidderNo As String = Me.txtBidderNo.Text
Dim strCompany1 As String = Me.txtCompany1.Text
'Get a reference of the column to be compared
colBidderNo = GridEX1.RootTable.Columns("bidderno")
colCompany1 = GridEX1.RootTable.Columns("company1")
'Create the condition
Dim condition As New GridEXFilterCondition
If strBidderNo > "" Then
condition.AddCondition(New GridEXFilterCondition(colBidderNo, ConditionOperator.Contains, strBidderNo))
End If
If strCompany1 > "" Then
condition.AddCondition(New GridEXFilterCondition(colCompany1, ConditionOperator.Contains, strCompany1))
End If
''Assign the condition to the table to filter the records
If condition.Conditions.Count > 0 Then
GridEX1.RootTable.FilterCondition = condition
End If
End Sub