1. Home
  2. Forum
  3. Blazor
  4. Grid column lookup using SFCombobox not working

Grid column lookup using SFCombobox not working

Hello,

I try to create a lookup on column OrganisaztionID by replacing the current view with Combobox. The Combobox should link to the Organisation list. But the concept does not work.


Please help

Please see the screenshots and code in the attached files




Attachment: Combobox_Lookup_3ee3a887.rar

5 Replies
SP Sarveswaran Palani Syncfusion Team June 28, 2022 03:58 PM UTC

Hi Sao,


Thanks for contacting Syncfusion support.


We have analyzed your query and found that combo box was rendered in text and value behavior, the same behavior can be achieved in grid using by ForeignKeyColumn feature of Grid. We have already discussed ForeignKeyColumn topic in our UG documentation. Kindly refer the attached UG documentation and demo link for your reference.  


Refer our UG documentation for your reference

https://blazor.syncfusion.com/documentation/datagrid/columns#foreign-key-column


Refer our Demo Link as well   

https://blazor.syncfusion.com/demos/datagrid/foreign-key-column?theme=fluent


Please get back to us if you have further queries.


Regards,

Sarveswaran PK


SA Sao June 28, 2022 09:02 PM UTC

Dear Support,

Thank you for your answer, however, your demo does not show how to bind data from EF context.

Could you please provide an example?


Regards

Sao


SP Sarveswaran Palani Syncfusion Team June 29, 2022 03:48 PM UTC

Hi Sao , 


Sorry for the Inconvenience.

We are currently Validating the reported query with high priority at our end, and we will update the further details within two business days. Until then we appreciate your patience.


Regards,

Sarveswaran PK



SP Sarveswaran Palani Syncfusion Team July 1, 2022 06:03 PM UTC

Hi Sao,


Based on your last update, We find a video related to your requirement. Please consider this as a custom sample. We promised to deliver a sample on or before the 6th July 2022. Kindly refer the attached video link for your reference


https://youtu.be/MEdHxxqeY9A

Regards,

Sarveswaran PK


VN Vignesh Natarajan Syncfusion Team July 5, 2022 06:30 AM UTC

Hi Sao,


Thanks for the patience


As promised we have prepared a sample with Entity Framework and Blazor Grid with the foreign key column. Kindly refer to the below sample for your reference


Note: to bind the datasource properly, kindly change the connection string of Northwind.MDF file from App_Data folder in the appsettings.json file.


Please get back to us if you have further queries.


Regards,

Vignesh Natarajan


Attachment: BlazorAppEFFK_3f34dcca.zip

Loader.
Up arrow icon