Hi Kenney,
Greetings from Syncfusion.
Query: How can I implement a nested Foreign Column such that I can reach AspNetUser to UserGroupHeader to get the 'GroupName' field?
We have validated your query and you want to bind the foreign key column when there is same mapping Field is not available in Foreign key datasource. If you don’t have same mapping field in your Grid datasource and foreign key datasource, then you can map both datasource by using ForeignKeyField property.
Reference:
ForeignKeyField - Defines the mapping column name to the foreign data.
Find the below code snippets for your reference.
|
<SfGrid @ref="Grid" DataSource="@Orders" Height="315" Toolbar="@(new List<string>() { "Add", "Edit", "Delete", "Cancel", "Update" })">
<GridEditSettings AllowAdding="true" AllowEditing="true" AllowDeleting="true"></GridEditSettings>
<GridColumns>
<GridForeignColumn Field=@nameof(Order.EmployeeID) HeaderText="Employee Name" ForeignKeyField="ID" ForeignKeyValue="FirstName" ForeignDataSource="@Employees" Width="150"></GridForeignColumn>
. . .
</GridColumns>
</SfGrid>
@code{
SfGrid<Order> Grid;
public List<Order> Orders { get; set; }
public List<EmployeeData> Employees { get; set; }
protected override void OnInitialized()
{
Orders = Enumerable.Range(1, 5).Select(x => new Order()
{
OrderID = 1000 + x,
EmployeeID = x,
Freight = 2.1 * x,
OrderDate = DateTime.Now.AddDays(-x),
}).ToList();
Employees = Enumerable.Range(1, 5).Select(x => new EmployeeData()
{
ID = x,
FirstName = (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? ID { get; set; }
public string FirstName { get; set; }
}
} |
Query: How do I access the Data Grid values in the Foreign Column in my 'OnActionComplete()' event method? Currently, I am only able to access non-foreign columns. (ForeignColumn TValue = UserGroup)
We have validated your query and we suspect that you want to access foreign key data for corresponding edited data. If yes, then you can find the corresponding foreign data by using below way.
|
<SfGrid @ref="Grid" DataSource="@Orders" Height="315" Toolbar="@(new List<string>() { "Add", "Edit", "Delete", "Cancel", "Update" })">
<GridEditSettings AllowAdding="true" AllowEditing="true" AllowDeleting="true"></GridEditSettings>
<GridEvents OnActionBegin="ActionBeginHandler" OnActionComplete="ActionCompletedHandler" TValue="Order"></GridEvents>
<GridColumns>
. . .
</GridColumns>
</SfGrid>
@code{
SfGrid<Order> Grid;
. . .
public void ActionCompletedHandler(ActionEventArgs<Order> args)
{
if(args.RequestType == Syncfusion.Blazor.Grids.Action.Save)
{
var fData = Employees.Where(or => or.ID == args.Data.EmployeeID).FirstOrDefault();
}
}
} |
Please let us know if you have any concerns.
Regards,
Rahul
