I need the ablility to select multiple values for a cell where these values are dependent on the value of another cell in the same row. I can get the multiple values to work via the UltraCombo and a similar approach as suggedted in article "Creating a dropdown list in a grid cell whose list values are dependent on another cell" (http://news.infragistics.com/winforms/codesamples/creating-a-dropdown-list-in-a-grid-cell-whose-list-values-are-dependent-on-another-cell.aspx).
The only problem is that when the row is deactivated I lose the display of the multiselected values (the cell appears empty) but when the cell is activated the values are re-displayed.
The UltraCombo is bound to a UltraDataSource and all possible values of the cell are loaded. I listen for the BeforeCellActivate event for that cell and apply a filter to the UltraCombo to only show the rows that match the value of the "other" cell (see above referenced article). The CheckStateMember is an unbound column in the UltraComboEditor (not defined in the UltraDataSource).
Is there a different approach to this problem or can you suggest what I am doing wrong?
Thanks...
P.S., using 2011.1
Hi,
I have create a case for you with reference number CAS-71010-77Z0BG. Please if you have any questions, do not hesitate to ask me through the case or this forum thread.
Regards
Georgi
Thanks Mike for your quick response and follow-up on this issue!
I tried this out by downloading the sample from the Community Site article you referenced here and adding a new column to it that allows you to multi-select cities. I get the same results you are describing.
This looks like it might be a bug. The multi-select column is failing to match up the DataValue and DisplayText for the multi-select column because of the filtering. It's supposed to be able to find the items even though they are filtered out of the list, just like it does in the single-select City column.
It might be that it's not possible to do this, since the multi-select column is always using DropDownList style and therefore it's value always has to match an item on the list. But it's also possible that this is just a bug or an oversight.
I have forwarded this thread over to Infragistics Developer Support so they can create a case for you and write this issue up for developer review.
Are there any other appoaches to this? Someone must have figured out how to do this without creating a UltraCombo for each cell....
My guess is when a new filter is applied to the UltraCombo, the rows that correspond to the values of the last cell are hidden, and as such are unavaliable to the last cell, so it can't show them. One solution is to assign a different UltraCombo to each cell, although in cases where you have a relatively large number of cells, this will cause more memory usage.