Log In
[Expand]Welcome to DevExpress .NET Documentation
[Expand]WinForms Controls
[Collapse]ASP.NET Controls and MVC Extensions
 [Expand]What's Installed
 [Expand]Common Concepts
 [Collapse]ASP.NET WebForms Controls
   Getting Started
  [Expand]Chart Control
  [Collapse]Grid View
   [Expand]Product Information
    Getting Started
    [Expand]Binding to Data
    [Expand]Data Representation Basics
    [Expand]Focus and Navigation
    [Expand]Data Editing
    [Collapse]Data Shaping and Manipulation
     [Expand]Data Summaries
       Filtering in Code
       Filter Row
       Filter Control
       Header Filter
       Search Panel
      Cell Merging
    [Expand]Data Formatting
    [Expand]Master-Detail Relationship
     Appearance Customization
     Save and Restore Layout
    ASPxGridView Designer
   [Expand]Visual Elements
   [Expand]Member Tables
   [Expand]ASPxGridView - Animated Images
  [Expand]Card View
  [Expand]Vertical Grid
  [Expand]Rich Text Editor
  [Expand]Image and Data Browsing
  [Expand]Docking and Popups
  [Expand]Site Navigation and Layout
  [Expand]File Management
  [Expand]Multi-Use Site Controls
  [Expand]HTML Editor
  [Expand]Pivot Grid
  [Expand]Tree List
  [Expand]Data Editors
  [Expand]Spell Checker
  [Expand]Query Builder
 [Expand]ASP.NET MVC Extensions
 [Expand]Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Report Server
[Expand]eXpressApp Framework
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation


Expanded Overview

Filtering allows you to display a subset of records that meet certain criteria in the data source. When filtering is applied to ASPxGridView, only data rows that meet the specified criteria are displayed. Data can be filtered against a single data column or multiple data columns.

ASPxGridView allows its data to be filtered by column values or display text. This is controlled by the column's GridDataColumnSettings.FilterMode property. Filtering by display text is ignored in database server mode.

End-users can build simple filter criteria, and apply it using the Filter Row or the Header Filter of a column.

The comparison operator used in a filter condition is determined by the GridViewDataColumnSettings.AutoFilterCondition property of a column. End-users can select the filter condition via the context menu, which is invoked by clicking a filter row button. The following eleven operators are available.

  • Begins with
  • Contains
  • Doesn't contain
  • Ends with
  • Equals
  • Is greater than
  • Is greater than or equal to
  • Is less than
  • Is less than or equal to
  • Doesn't equal
  • Like ('%', '_')

Complex filter expressions can be applied in code or by using the Filter Control, which can be invoked by clicking the Filter Bar. The visibility of the filter bar is controlled by the ASPxGridSettings.ShowFilterBar option.

Expanded Concepts

Expanded Member Table

Expanded Task-Based Help

Is this topic helpful?​​​​​​​