SqlDataSource.CustomizeFilterExpression Event

Allows you to include WHERE clauses in SQL queries.

Namespace: DevExpress.DataAccess.Sql

Assembly: DevExpress.DataAccess.v19.2.dll

Declaration

public event CustomizeFilterExpressionEventHandler CustomizeFilterExpression
Public Event CustomizeFilterExpression As CustomizeFilterExpressionEventHandler

Event Data

The CustomizeFilterExpression event handler receives an argument of the CustomizeFilterExpressionEventArgs type. The following properties provide information specific to this event.

Property Description
FilterExpression Gets or sets the filter expression that defines a WHERE clause included in the SQL query.
QueryName Gets the name of the query for which the event was raised.

Remarks

The CustomizeFilterExpression event is fired when the SqlDataSource sends a query to reload data from the server (for instance, on the SqlDataSource.Fill method call). Use the event parameter's CustomizeFilterExpressionEventArgs.FilterExpression property to specify a filter expression to be included in this query as a WHERE clause.

The filter expression should be represented by the CriteriaOperator descendant. To learn how to create the appropriate object, see Creating Criteria. Use the CustomizeFilterExpressionEventArgs.QueryName property to identify the query for which the event has been raised.

NOTE

The CustomizeFilterExpression event is fired only for queries represented by the SelectQuery or TableQuery classes.

You can also handle the SqlDataSource.ConfigureDataConnection event to specify connection parameters on the fly.

See Also