We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback


The WPF DataGrid control provides support to filter data with an intuitive, built-in, Excel filter user interface and filter row. It’s also possible to filter data in code behind. Sort the columns in ascending or descending order easily using the filter UI itself. Also display text-based filtering.

Excel-inspired check list box filter UI

An Excel-inspired filter UI filters records. The filter UI contains a check list box for selecting items so users can filter records easily.

WPF DataGrid Filter like Excel

Advanced Excel-inspired filter UI

Users can filter data easily by using multiple options provided in the filter UI. Built-in filter types:

  • Text filters
  • Number filters
  • Date filters using date picker

WPF DataGrid Advanced Filter like Excel

Text filter

Text filter menu options are loaded when the column’s underlying property is string or dynamic. The following options are available:

  • Equals
  • Does Not Equal
  • Begins With
  • Ends With
  • Contains
  • Does Not Contain
  • Empty
  • Not Empty
  • Null
  • Not Null

WPF DataGrid Text Filter UI like Excel

Number filter

When the column’s underlying property is integer, double, short, decimal, byte, or long, number filter menu options are loaded. The following number filter options are available:

  • Equals
  • Does Not Equal
  • Null
  • Not Null
  • Less Than
  • Less Than or Equal
  • Greater Than
  • Greater Than or Equal

WPF DataGrid Number Filter UI like Excel

Date filter

Load various date filter options when the column’s underlying property is date-time. The date-time can be selected intuitively by using a date picker. The following date filter options are available:

  • Equals
  • Does Not Equal
  • Before
  • Before or Equal
  • After
  • After or Equal
  • Null
  • Not Null

WPF DataGrid Date Filter UI like Excel

Instant filtering

You can allow users to update the filters immediately whenever updating the filter UI pop-up.

WPF DataGrid Filter UI with Instant Option

Filter row

The WPF DataGrid control provides a built-in row called a filter row to filter the individual column values. Editors for the filter row can be loaded based on the underlying column property type to filter data easily. Built-in editors:

  • TextBox
  • Numeric
  • ComboBox
  • Multiselect ComboBox
  • CheckBox
  • DateTime

Filter row documentation

WPF DataGrid Filter Row


Scroll up icon

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon