GridGroupingControl and listboxes

Hello we are using a syncfusion GridGroupingControl to insert some products into our DB. We set the product hierarchy (family and type) and enter the product code. the hierarchy database table look like this : family1 type1 family1 type2 family2 type3 family2 type4 so the 2 first columns are listboxes (for family and type) and the third one is a normal text cell (for product code). it looks like this : family column | type column | product code ------------------------------------------ (listbox) | (listbox) | (textbox) the thing we would like to do is filter the type depending on the family selected : when I select family1 : only type1 and type2 should be available in the second list box when I select family2 : only type3 and type4 should be available in the second list box Is there a way to do that in the GridGroupingControl ? If yes, do you have an example to show me ? Thanks, Yves

3 Replies

AD Administrator Syncfusion Team December 8, 2005 05:31 PM UTC

One way you can do this is to handle events and dynamically filter the droplist when it dropped using these events. Here is a little sample showing this. http://www.syncfusion.com/Support/user/uploads/GGC_ComboBoxes_dbc554b7.zip


AD Administrator Syncfusion Team December 9, 2005 05:32 PM UTC

thanks just on thing : use the event CurrentCellChanged instead of CurrentCellChanging else it doesn''t update the first column.


YL yves lothier December 20, 2005 04:30 PM UTC

I''m using the same logic in my dev. But in fact I have a 3 columns table : ID, Label, ParentID I display the Label but I have the ID stored behind. and so the problem is that when I select a value in a combo, the next column datatable gets filtered and so the other lines can have ID displayed instead of Label because the dataTable is filtered for the whole column. So, is there a workaround ? Maybe it''s possible to set different datatable per cell not per column (but it seems a bit heavy) ? Thanks

Loader.
Up arrow icon