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
Syncfusion Feedback


Overview

The WinForms 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 the ascending or descending order easily using the filter UI itself. Also display text-based filtering.


Excel-inspired checked listbox filter UI

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

Excel like checked listbox filtering ui in winforms datagrid


Advanced Excel-inspired filter UI

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

  • Text filters
  • Number filters
  • Date filters using datepicker

Advanced filtering ui in winforms 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 winforms 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 winforms 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 the 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 winforms datagrid


Instant filtering

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

Instant filtering using advanced filtering ui in winforms datagrid


Filter row

The WinForms DataGrid control provides a built-in row called a filter row to filter 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 are:

  • TextBox
  • Numeric
  • ComboBox
  • Multiselect ComboBox
  • CheckBox
  • DatePicker

Filtering using filter row in winforms datagrid


95+ WINDOWS FORMS CONTROLS

Scroll up icon