ForeignKeyValue Template Column

Question

Hi,I want to use multiple columns for my foreign key. For example, in te below Scenario, I want to use ProjectNo + ProjectRevision And also in the combo box, I want to load the same.Is it possible?Thanks

Jeevakanth Palaniappan · Answer

Hi Hajir, 

Greetings from Syncfusion support. 

We have checked your query but we are quite unclear about your exact scenario since we don’t know the model class details. So please share us the below details which will be helpful for us to validate your query. 


Provide more information on your query.
Do you want to show the data of two field properties from the ForeignKey class? 
Share us the model class of grid and foreignkey model class.

Regards, 
Jeevakanth SP.

Hajir · Answer

Hi, Thank you for your reply. Sure.I have a PML class which has a foreign key to Drawnig table as below:public class PML : BaseEntity { public int Id {get; set;} public int? DrawingId { get; set; } public Drawing Drawing { get; set; } public string DocumentNo { get; set; } }And in my Drawing Class I have multiple properties:public class Drawing : BaseEntity { public string DrawingName { get; set; } public string SheetNo { get; set; } public string Revision { get; set; } public int? PMLId { get; set; } public PML PML { get; set; } }This is my Blazor client side page: @code { private List Drawings { get; set; } private List Paintings { get; set; } protected override async Task OnInitializedAsync() { Drawings = await DrawingRepository.GetAll(); Paintings = await PaintingRepository.GetAll(); await base.OnInitializedAsync(); }} Here the user can see the DrawingNo through the foreign key PML.DrawingID and also select the desired DrawingNo from combo box which is great.But since drawings have different sheets and revisions, I need to display DrawingNo + SheetNo + Revision (in a table or string) on both row and combo box.I found this article which is great, but I want something similar for combobox and foreign key.Thanks

Jeevakanth Palaniappan · Answer

Hi Hajir, Thanks for sharing the details. We have prepared a sample based on your requirement in which we have used column template feature of grid and ItemTemplate of Combo box. Please refer the complete code snippet and documentation below for your reference. Documentation: https://blazor.syncfusion.com/documentation/datagrid/columns#column-template https://blazor.syncfusion.com/documentation/combobox/templates#item-template @using Syncfusion.Blazor.Grids @using Syncfusion.Blazor.DropDowns @{ EmployeeData ForeignKeyData = Employees.Where(x => x.EmployeeID == ChildContext.EmployeeID).FirstOrDefault(); @ForeignKeyData.FirstName @ForeignKeyData.LastName } @code{ public List Orders { get; set; } public List Employees { get; set; } protected override void OnInitialized() { Orders = Enumerable.Range(1, 75).Select(x => new Order() { OrderID = 1000 + x, EmployeeID = x, Freight = 2.1 * x, OrderDate = DateTime.Now.AddDays(-x), }).ToList(); Employees = Enumerable.Range(1, 75).Select(x => new EmployeeData() { EmployeeID = x, FirstName = (new string[] { "Nancy", "Andrew", "Janet", "Margaret", "Steven" })[new Random().Next(5)], LastName = (new string[] { "Nancy", "Andrew", "Janet", "Margaret", "Steven" })[new Random().Next(5)], }).ToList(); } public class Order { public int? OrderID { get; set; } public int? EmployeeID { get; set; } public DateTime? OrderDate { get; set; } public double? Freight { get; set; } } public class EmployeeData { public int? EmployeeID { get; set; } public string FirstName { get; set; } public string LastName { get; set; } } } Regards, Jeevakanth SP.

Hajir · Answer

Thank you so much for the reply.Is it possible to show the text same as template when we go to edit mode? for example, my template shows Drawing No + Revision. When we go edit mode, I want the text to display Drawing No + Revision as well. Thanks. @{ @ChildContext.DrawingNo Rev.@ChildContext.Revision }

Jeevakanth Palaniappan · Answer

Hi Hajir, We suspect that you want to customize the input shown in the Combo box while editing a record. If so we suggest you to achieve your scenario by using the DropDownList instead of Combo box. In DropDownList, you can set the ValueTemplate to achieve your scenario. Please refer the below code snippet, documentation and the sample for your reference. Documentation: https://blazor.syncfusion.com/documentation/dropdown-list/templates#value-template Sample : https://www.syncfusion.com/downloads/support/directtrac/general/ze/ServerApp1904641711 @using Syncfusion.Blazor.Grids @using Syncfusion.Blazor.DropDowns @{ EmployeeData ForeignKeyData = Employees.Where(x => x.EmployeeID == ChildContext.EmployeeID).FirstOrDefault(); @ForeignKeyData.FirstName @ForeignKeyData.LastName } @{ EmployeeData ForeignKeyData = Employees.Where(x => x.EmployeeID == ChildContext.EmployeeID).FirstOrDefault(); @ForeignKeyData.FirstName @ForeignKeyData.LastName } @code{ public List Orders { get; set; } public List Employees { get; set; } protected override void OnInitialized() { Orders = Enumerable.Range(1, 75).Select(x => new Order() { OrderID = 1000 + x, EmployeeID = x, Freight = 2.1 * x, OrderDate = DateTime.Now.AddDays(-x), }).ToList(); Employees = Enumerable.Range(1, 75).Select(x => new EmployeeData() { EmployeeID = x, FirstName = (new string[] { "Nancy", "Andrew", "Janet", "Margaret", "Steven" })[new Random().Next(5)], LastName = (new string[] { "Nancy", "Andrew", "Janet", "Margaret", "Steven" })[new Random().Next(5)], }).ToList(); } public class Order { public int? OrderID { get; set; } public int? EmployeeID { get; set; } public DateTime? OrderDate { get; set; } public double? Freight { get; set; } } public class EmployeeData { public int? EmployeeID { get; set; } public string FirstName { get; set; } public string LastName { get; set; } } } Get back to us if you have any other queries. Regards, Jeevakanth SP.