Janus System

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