Filter Row

Friday, July 4, 2014 France Queso Cabrales $14.00 12
Friday, July 4, 2014 France Singaporean Hokkien Fried Mee $10.00 10
Friday, July 4, 2014 France Mozzarella di Giovanni $35.00 5
Saturday, July 5, 2014 Germany Tofu $19.00 9
Saturday, July 5, 2014 Germany Manjimup Dried Apples $42.00 40
Tuesday, July 8, 2014 Brazil Jack's New England Clam Chowder $8.00 10
Tuesday, July 8, 2014 Brazil Manjimup Dried Apples $42.00 35
Tuesday, July 8, 2014 Brazil Louisiana Fiery Hot Pepper Sauce $17.00 15
Tuesday, July 8, 2014 France Gustaf's Knäckebröd $17.00 6
Tuesday, July 8, 2014 France Ravioli Angelo $16.00 15

Enable the ShowFilterRow option to display a row that allows users to filter grid data. This row displays different in-place editors based on the column types. Users can filter data as follows:

  • DxDataGridDateEditColumn (Order Date) - Select a date from the drop-down calendar or type a date in the editor and press Enter.
  • DxDataGridComboBoxColumn (Ship Country) - Select an item from the drop-down list or type text into an editor to filter its items on-the-fly.
  • DxDataGridColumn (Product Name) - Type text in the editor and press Enter.
  • DxDataGridSpinEditColumn (Unit Price and Quantity) - Click spin buttons or type a value in the editor and press Enter.

Each editor contains a clear button that resets the filter by the corresponding column. Use DxDataGridCommandColumn to display the common clear button that resets the entire filter. You can also use the AllowFilter property to prevent users from filtering data by individual columns.