There may be times in which you might want to use different editors for fields in WebHierarchicalDataGrid™. You can do so through the use of editor providers.
On an editing-enabled WebHierarchicalDataGrid control, the most appropriate editor provider will be used on each column depending on the column’s data type. For example, numeric and DateTime data type columns will automatically use the NumericEditorProvider and the DateTimeEditorProvider respectively. However, if you wish to override this default functionality, you can always specify your own editor provider(s). This allows you to provide different editors you deem more appropriate for each column. The available editor providers are:
Some of the editor providers used by default depending on the data type of WebHierarchicalDataGrid’s columns are listed below. The following table lists the data types and their associated editors.
To use editor providers, add them to the EditorProviders collection. Once added, you can access an editor provider with its Id and assign it to a particular column.
The following walkthrough shows how to use EditorProviders with your WebHierarchicalDataGrid control.
Bind WebHierarchicalDataGrid to a WebHierarchicalDataSource™ component retrieving data from the Orders and Order Details tables. For more information on doing this, see the Using WebHierarchicalDataSource topic.
In the Microsoft® Visual Studio™ property window, locate the EditorProviders property and click the ellipsis (…) button to launch the Editor Providers Designer.
Click the Plus (+) button to drop-down a list of possible editors. Select two Editors, one for the parent band and one for the child band to make it available later when you are setting up columns. For our purposes, select the DatePickerProvider and the SliderProvider.
Leave the ID for the editors as WebHierarchicalDataGrid1_DatePickerProvider1 and WebHierarchicalDataGrid1_SliderProvider1 in the property grid on the right. You will need this ID later when setting the editors for columns.
You can set any additional properties for the editor controls by expanding the EditorControl property. For this topic, expand the EditorControl property of the SliderProvider. Set values for the following properties:
MaxValue – 150
MinValue – 0
ValueType – Int
Click Apply then OK to close the designer
Locate the Bands property and click the ellipsis (…) button to launch the Edit WebHierarchicalDataGrid Bands Dialog.
In this window you can set properties for the parent and child bands. Locate the Behaviors property from the property grid on the right for the parent band. Click the ellipsis (…) button to launch the Edit Grid Behaviors dialog.
Check the CellEditing behavior in the list on the left to enable editing.
Locate the ColumnSettings property in the property grid on the right and click the ellipsis (…) button to launch the Column Settings Editor Dialog.
Configure parent band of WebHierarchicalDataGrid to use the DatePickerProvider for editing of the RequiredDate column.
Add a column setting by clicking add item.
Set the ColumnKey as RequiredDate.
For the EditorID property, click the dropdown list and select
WebHierarchicalDataGrid 1_DatePickerProvider1. Only editors that are added to the EditorProviders collection are available here. .. Leave ReadOnly as False. .. Click OK in the Column Setting and Edit Grid Behaviors dialog windows.
Follow steps 8 to 10, but this time to configure the child band.
Configure child band of WebHierarchicalDataGrid to use the SliderProvider for editing of the Quantity column.
Add a column setting by clicking add item.
Set the ColumnKey as Quantity.
For the EditorID property, click the dropdown list and select WebHierarchicalDataGrid1_SliderProviderProvider1. Only editors that are added to the EditorProviders collection are available here.
Leave the ReadOnly property as False.
Click OK in the Column Setting and Edit Grid Behaviors dialog windows.
Click OK to close the Edit WebHierarchicalDataGrid Bands dialog.
Run your application. When you enter edit mode in a cell of the RequiredDate column, the DatePickerProvider displays. Similarly when you enter edit mode in a cell of the Quantity column within the child band, the SliderProvider displays.
