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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback


Overview

The 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.

Excel like checked listbox filtering ui in wpf datagrid


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

Advanced filtering ui in wpf datagrid


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

Advanced filtering with text filter options in wpf datagrid


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

Advanced filtering with number filter options in wpf datagrid


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

Advanced filtering with date filter options in wpf datagrid


Instant filtering

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

Instant filtering using advanced filtering ui in wpf datagrid


Filter row

The 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

Filtering using filter row in wpf datagrid


90+ WPF CONTROLS

Scroll up 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.