GetFilterExpression Method

GetFilterExpression()

Declaration

public string GetFilterExpression()

Returns

Remarks

Examples

Example shows how to build a row filter using GetFilterExpression() method.

' 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</code></pre>