The following example shows how to use the ASPxDashboard.CustomFilterExpression event to filter an SQL query at runtime:
- e.QueryName - checks the name of the query that should be filtered.
- e.FilterExpression - specifies the filter criteria.
This example filters the Invoices
query with the following expression: "Customers.CompanyName" equals "Around the Horn".
- WebForm1.aspx (VB: WebForm1.aspx)
- WebForm1.aspx.cs (VB: WebForm1.aspx.vb)