ASPxGridBase.FilterExpression Property

Namespace: DevExpress.Web

Assembly: DevExpress.Web.v21.2.dll

Declaration

[DefaultValue("")]
public string FilterExpression { get; set; }

<DefaultValue("")>
Public Property FilterExpression As String

Property Value

Remarks

Concept

• ASPxGridView - Filtering
• Criteria Language Syntax
• Criteria Operators

Examples

The following examples illustrate different scenarios on how to filter the grid data.

• Filter data by dates.

  • C#
  • VB.NET

  DateTime date1 = new DateTime(1995, 1, 1);
  DateTime date2 = new DateTime(1995, 7, 1);
  string filter = String.Format("[OrderDate] > #{0}# And [OrderDate] < #{1}#",
                      date1.ToShortDateString(), date2.ToShortDateString());
  ASPxGridView1.FilterExpression = filter;
  

• Applying a filter that selects departments whose budget is greater than 100,000 and that are located in Monterey. The filter criteria are displayed within the ASPxGridView’s Title Panel.

  • C#
  • VB.NET

  ASPxGridView1.FilterExpression = "[Budget] > 100000  AND [Location] = 'Monterey'";
  ASPxGridView1.SettingsText.Title = ASPxGridView1.FilterExpression;
  

  Result:

  

• Select data rows whose product name starts with “ch”.

  • C#