0

Is there a DataGridView-derived or DataGridView-like grid for WinForms that shows both filters for each column and a summary row?

There is a CodeProject FilterableDataGrid and a CodeProject Summary DataGridView, but they can't be mixed together because FilterableDataGrid inherits from the obsolete DataGrid, while the Summary DataGridView inherits from DataGridView, so I can't make one inherit from the other.

What I'd like is a control that has the functionlity of both.

Requirements:

  • Winforms (not WPF).
  • Show both filters and a summary row.

Preferred:

  • Is free.
  • Filters allow searching by text, and for numeric and datetime columns searching by more, less or a range, in addition to just enumerating values.
1

Syncfusion GridGroupingControl for Windows Forms supports filters and summary rows (as well as other features such as sorting , grouping, nested tables etc.)

Filtering

GridGroupingControl provides support for filtering with normal Filterbar, dyanamic filter bar and Excel like filter.

  1. FilterBar

FilterBar provides support to select or type in the filter bar to filter the items from the filter drop down for the particular column.

  1. Dynamic Filter

Dynamic filter provides support for filtering the items with dynamic filter drop down options and typing on the dynamic filter bar with the implementation of GridDynamicFilter class for GridGroupingControl.

  1. Excel like Filter

GridExcelFilter provides support for filtering the items like Excel support. It provides support for Text filter, Number filter, Date filter and Color filter. GridExcelFilter might suit your requirement as it provides support for number filter and date filter.

Grid filter

Summaries

GridGroupingControl provides support for summarizing the columns.

Grid summary

Free License

The whole suite of controls and libraries is available for free through the community license program if you qualify (less than 1 million USD in revenue). Note: I work for Syncfusion.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.