' raised when the filter changes
Private Sub C1TrueDBGrid1_FilterChange(ByVal sender As Object, ByVal e As System.EventArgs) Handles C1TrueDBGrid1.FilterChange
   ' build our filter expression
   Dim sb As New System.Text.StringBuilder()
            
   Dim dc As C1.Win.C1TrueDBGrid.C1DisplayColumn
            
   For Each dc In Me.C1TrueDBGrid1.Splits(0).DisplayColumns
     ' get the filter expression for the column
     Dim cond As String = dc.GetFilterExpression()
     If cond <> "" Then
       If sb.ToString() <> "" Then
         sb.Append(" AND ")
       End If
       sb.Append(cond)
     End If
            
  Next dc
  ' filter the data
  Me.DataSet11.Tables(0).DefaultView.RowFilter = sb.ToString()
End Sub