Foreign Key Column

[Predrag]

I have the following columns in my bindingsource BookID, Name, Price, StatusID. StatusID is a foreign key.

Another table has the following columns StatusID, Status_Name.

I want Radgridview to contain the following columns: Name, Price, Status_Name. How can I do that? I cann't do that by a query because I will loose update capabilities of my tableadapter. Should I do that by templates? How can I accomplish this?

Thanks! 

 

[Predrag]

I found a solution by combobox column.

[Dess | Tech Support Engineer, Principal]

Hello Predrag,

Thank you for writing.

Indeed, the GridViewComboBoxColumn is the appropriate solution for this case. Please, make sure that the GridViewComboBoxColumn.FieldName property is set to "StatusID". Additionally, it is necessary to set the ValueMember property to "StatusID" as well because the grid cell belonging to this column contains the respective Id.

I hope this information helps. Should you have further questions, I would be glad to help.

 

Regards,
Dess
Telerik