When a grid has 'co'/'coro' columns ( select/combo-box ), it will automatically request data for them in the same manner as for Filtering options. So it's possible to use a similar way of logic to define which list of values needs to be used in select/combo inside of the grid.
an automatic list - if no custom instruction is provided , the grid will use DISTINCT select for the related field, and fetch all the possible options
a hardcoded list
connector.ExplicitOptions.Add( connector.Request.RequestedFields, "Alpha", "Beta", "Gamma" ); //or connector.ExplicitOptions.Add((TableField)"FieldName", "Alpha", "Beta", "Gamma");
The example above will add 3 options ("Alpha", "Beta", "Gamma") to the filter associated with the first column.
dhtmlxOptionsConnector filterConnector = new dhtmlxOptionsConnector( "Country", "ISO", connector.Request.Adapter ); //attach a filter connector to the first column of grid connector gridConnector.OptionsConnectors.Add( connector.Request.RequestedFields, filterConnector );
First of all, we create dhtmlxOptionsConnector to fetch items, specify a table and a field name to take options title from, and then provide a database adapter (Request.Adapter) already created for gridConnector.
Finally, we add the options connector to the first field of gridConnector.Back to top