Drop-down Filter
A column’s drop-down filter allows you to filter data at runtime. The drop-down filter displays a column’s unique values.
To filter data against a column, an end user should click the filter button () in a column header and select any item(s):
#Availability
A user can invoke a column’s drop-down filter if the view’s DataViewBase.AllowColumnFiltering property is set to true. Grid columns contain the ColumnBase.AllowColumnFiltering property that allows you to override a view’s default behavior. You can also set a column’s ColumnBase.FilterPopupMode property to Disabled to hide the filter button from this column’s header. This option still allows users to filter this column’s data in the Filter Editor.
#Rounding Seconds for TimeOnly Values
Within the drop-down filter, TimeOnly values are rounded to minutes, ignoring seconds and milliseconds. For instance, a condition like [Time] >= 7:44 and [Time] < 7:45 is shown as [Time] = 7:44. User data is not affected.
#Drop-down Filter Modes
The drop-down filter can work in different modes. Use the ColumnBase.FilterPopupMode property to change the drop-down filter’s mode.