GridComboBoxColumn binding question

[Xavi]

Hi,

I have created a SfDataGrid and binded the itemsource with a viewmodel that comes from ADO.NET Entity Framework in the same way as in your documentation.

I need to have a column of type GridComboBoxColumn but I have problems when it comes to bind its value and display a different value.

Let's say I have a model class Type with two properties (int id, string type), and another class A with two properties (int name, int typeId), this class A has a navigation to the class Type (foreign key typeId points to id from Type). And the viewmodel has an ObservableCollection.

The combobox column should display the string type from the class Type but whenever the user changes its value through the combobox (whos itemsource is filled with a query that selects all the string types) to a different one then the actual value that needs to be changed is the foreign key called typeId.

To summarize, I want a combobox that displays a certain property but actually the value changed is a different one that represents a navigation in the model. How can I accomplish this with data binding?

I know I can accomplish this by manually coding the logic behind, implementing RowValidated event or CurrentCellValidated event for example, nonetheless I want to know if through binding I can do this easier and faster.

Waiting for a response

[Sathiyathanam Jeyakumar]

Hi Xavi, 

 

Thank you for contacting syncfusion support. 

 

We have analyzed your query and we suspect that you have required to load the different ItemsSource to each row of GridComboBoxColumn. You can achieve this requirement by using the ItemSourceSelector property of GridComboBoxColumn. In each row you can load the string type items in the GridComboBoxColumn based on the typeId. 

 

You can refer the ItemsSourceSelector and its uses from the below UG/ KB link. 

 

https://help.syncfusion.com/wpf/sfdatagrid/column-types#loading-different-itemsource-for-each-row-of-gridcomboboxcolumn 

 

 

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

 

Sample Link : ComboBoxColumnsDemo-1585046085.zip 

 

 

Dashboard Sample Location: C:\Users\Public\Documents\Syncfusion\WPF\{installed Syncfusion ES build version}\SfGrid.WPF\Samples\ComboBoxColumnsDemo 

 

Sample Explanation: The following screenshot illustrates the different ShipCity ItemsSource bound to each row of the ComboBox based on the Country Name. 

 

 

 

Please let us know if you need any further assistance on this. 

 

Regards, 

Sathiyathanam 

[Xavi]

I finally got it working.

I didn't actually need to change the ItemsSource for each row (every row with the same ItemsSource).

Using the MappingName, DisplayMemberPath and SelectedValuePath did the trick.

Thanks for the help!

[Jai Ganesh S]

Hi Xavi,  

 

Thank you for the update. 

 

Please let us know if you need further assistance on this. 

 

Regards, 

Jai Ganesh S