The Data Grid was moved to maintenance support mode. No new features/capabilities will be added to this component. We recommend that you migrate to the Grid component.
Order Date
|
Ship Country
|
Product Name
|
Unit Price
|
Quantity
|
|
|---|---|---|---|---|---|
|
|
|
|
|
|
|
| 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 |
of 216
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.