# C1.Win.TrueDBGrid.C1DisplayColumn.GetFilterExpression ## Content

GetFilterExpression Method

GetFilterExpression()

Gets the filter expression for the column.

Declaration
public string GetFilterExpression()
Public Function GetFilterExpression() As String
Returns
Type Description
string

The filter expression for the column
Remarks

Use this method in your implementations of custom filtering.

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.TrueDBGrid.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>