How to correctly manage filtered combo-boxes on sfDataGrid

[Silvio]

Hi,

I'm not able to correctly manage an sfDataGrid with a combo-box cell inside it where the combo-box itemSource changes according to the current selected record (the combo-box list is filtered).

I have implemented a possible solution that is not acceptable cause some side effects.

I have explained everything in the solution I attach below.

Inside it you can find both che C# project and a video that better explains my requirements and my actual not correct solution.

Have you any sugestion that can help me to correctly implement this filtered behavior ?

Thank you,

Silvio

Attachment: GridFilteredCombo_764a47ab.zip

[Muthukumar Kalyanasundaram]

Hi Silvio, 

 

Thank you for contacting Syncfusion support. 

We have checked your provided video file. We are unable to get your exact requirement, we suspect that your requirement is to Filter the ItemsSource bounded to the ComboBox. For example if we have ItemsSource collection A,B and C for bounding it to the comboBox. If the cell Display value is B means, your requirement is to filter the ItemsSource collection with B and at the result bound the remaining collection (A & C) in to the ComboBox.  If your requirement is different from this, could you please share some more information about your requirement clearly ?.  This would be more helpful for us to proceed further. 

If you want to bind the different itemsource to each row of combobox, you can refer the below link 

Link: https://www.syncfusion.com/kb/4896/how-to-bind-different-itemssources-to-each-row-of-the-combobox-by-using-gridtemplatecolumn-in-the 

   

Please let us know if you have any query. 

 

Regards, 

Muthukumar K 

[Silvio]

Hi, 

thank you for this reply and your example.

Yes, probably your suspections are correct.

In fact, my need is not to change the ItemsSource for each different row in the grid.

My need is to have the possibility, having a unique global list for the ItemSource, to filter its content according to the current row (and relative binded record) and let the user be able to select, for each different record, only a subset (filtered) of the whole global ItemSource collection.

It is clearer now? Thank you.

Have a nice week end.

Silvio S.

[Muthukumar Kalyanasundaram]

Hi Silvio, 

Sorry for the delay. 

We have checked your query. It is not possible to achieve your requirement based on SelectedItem. But you can achieve your requirement to filter and set ItemsSource by writing customer renderer as in the below KB article. 

  

KB link: https://www.syncfusion.com/kb/5273/how-to-bind-different-itemssources-to-each-row-of-the-gridcomboboxcolumn 

In the above article ShipCount column ItemsSource are queried based on ShipCountry via ItemsSourceSelector. Please let us know if this help us to achieve your requirement.  

Regards, 

Muthukumar K 

[Silvio]

Dear Muthukumar

I have another different idea, if it is possible.

Surely when the ComboBox is opened an SfDataGrid is displayed.

So, is it possible to set View.Filter Predicate property of this SfDataGrid in order to implement in this passed method all my filtering related to the current grid selection?

If it is, can you show me how and where to set it ?

Thank you.

Silvio

[Muthukumar Kalyanasundaram]

Hi Silvio, 

 

Thanks for the update. 

 

We have checked your query. The purpose of View.Filter predicate is to filter SfDataGrid only, that we can’t use to filter ItemsSource for ComboBox. In below attached sample, we have created custom column and filter the comboBox data as shown like below code, 

 

Code Snippet: Xaml 

 

<local:GridComboBoxColumnExt DisplayMemberPath="CityName" 

                        MappingName="CityID" 

                        SelectedValuePath="CityID"> 

    <local:GridComboBoxColumnExt.ItemsSourceSelectorSelector> 

        <local:ItemsSourceSelectorSelector/> 

    </local:GridComboBoxColumnExt.ItemsSourceSelectorSelector> 

</local:GridComboBoxColumnExt> 

 

 

Code Snippet: C# 

 

public class ItemsSourceSelectorSelector : IItemsSourceSelector 

{ 

    public IEnumerable GetItemsSource(object record, object dataContext) 

    { 

        if (record == null) 

            return null;         

 

        //write ItemSource based on your record. 

         

    } 

} 

 

 

Sample: http://www.syncfusion.com/downloads/support/forum/131482/ze/GridComboBox_Demo-1967234606.zip 

 

Please let us know if you have any query. 

 

Regards, 

Muthukumar K 

[Silvio]

Dear Muthukumar,

the last example you have proposed me should be similar to what I'd like to obtain.

By I don't like to use GridComboBoxColumn in my SfDataGrid.

I'd like to use, instead, a GridMultiColumnDropDownList column that let me to show to the user more columns for each record.

It was for this reason that I sugested you if it was possible to use View.Filter Predicate, since it seems to me that this column type uses an SfDataGrid to display the popup where the user selects a record.

So, is it possible to have an example similar to the last one when a GridMultiColumnDropDownList column is used ?

Thank you,

Silvio

[Muthukumar Kalyanasundaram]

Hi Silvio, 

 

Sorry for the delay. 

 

As per your requirement. We have prepared sample with GridMultiColumnDropDownList control. For your reference, we have attached sample in below location. Could you please refer to it. 

 

Code Snippet: Xaml 

 

<local:GridMultiColumnExt DisplayMember="CityName" ItemsSource="{Binding OrderList}" 

                    MappingName="CityID" ValueMember="CityID" > 

    <local:GridMultiColumnExt.ItemsSourceSelectorSelector> 

        <local:ItemsSourceSelectorSelector/> 

    </local:GridMultiColumnExt.ItemsSourceSelectorSelector> 

</local:GridMultiColumnExt> 

 

 

You can use GridCellMultiColumnDropDownRenderer instead of GridCellComboBoxRenderer as like below code, 

 

Code Snippet: C# 

public class GridCellMultiComboBoxRendererExt : GridCellMultiColumnDropDownRenderer  

{ 

    public GridCellMultiComboBoxRendererExt() : base() 

    { } 

 

    public override bool CanUpdateBinding(GridColumn column) 

    { 

        return true;  

    } 

    public override void OnInitializeEditElement(DataColumnBase dataColumn, SfMultiColumnDropDownControl uiElement, object dataContext) 

    { 

        var customColumn = (GridMultiColumnExt)dataColumn.GridColumn; 

        //Setting ItemsSource for GridComboBoxColumn 

        if (customColumn != null && customColumn.ItemsSourceSelectorSelector != null) 

        { 

            object value = customColumn.ItemsSourceSelectorSelector.GetItemsSource(dataContext, DataGrid.DataContext); 

            customColumn.ItemsSource = value as IEnumerable; 

        } 

        base.OnInitializeEditElement(dataColumn, uiElement, dataContext); 

    } 

} 

 

 

public class ItemsSourceSelectorSelector : IItemsSourceSelector 

{ 

    public IEnumerable GetItemsSource(object record, object dataContext) 

    { 

        if (record == null) 

            return null; 

        //write ItemSource based on your record. 

    } 

} 

 

Sample: http://www.syncfusion.com/downloads/support/forum/131482/ze/GridComboBox_Demo-91884125 

 

Please let us know if you have any query. 

 

Regards, 

Muthukumar K