The Syncfusion native Blazor components library offers 70+ UI and Data Viz web controls that are responsive and lightweight for building modern web apps.
.NET PDF framework is a high-performance and comprehensive library used to create, read, merge, split, secure, edit, view, and review PDF files in C#/VB.NET.
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
ADAdministrator 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
ADAdministrator 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.
YLyves lothierDecember 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