This is a migrated thread and some comments may be shown as answers.

Data source uses ling query

1 Answer 184 Views

Grid

This is a migrated thread and some comments may be shown as answers.

ian asked on 21 Oct 2019, 07:09 PM

Can anyone help with this please?

The following HTML produces a satisfactory result in that all columns are populated:

if (purchaseOrders == null)

{

<p><em>Loading...</em></p>

}

else

{

<table class="table">

<thead>

<tr>

<th>PO No.</th>

<th>PO Date</th>

</tr>

</thead>

<tbody>

@foreach (var purchaseOrder in purchaseOrders)

{

<tr>

<td>@purchaseOrder.PurchaseOrderId</td>

<td>@purchaseOrder.PurchaseOrderDate.ToShortDateString()</td>

<td>@purchaseOrder.Supplier.SupplierName</td>

</tr>

}

</tbody>

</table>

}

There is a linq query in a service file which retrieves data across the FK between "Purchase Order" and "Supplier". However the SupplierName column remains blank in the Telerik grid with the following code:

<TelerikGrid Data="purchaseOrders" Height="800px"

Pageable="true" PageSize=@PageSize Sortable="true" Groupable="true"

FilterMode="Telerik.Blazor.GridFilterMode.FilterRow">

<GridColumns>

<GridColumn Field="@(nameof(PurchaseOrder.PurchaseOrderId))" Title="PO No." Groupable="false" />

<GridColumn Field="@(nameof(PurchaseOrder.PurchaseOrderDate))" Title="PO Date" />

<GridColumn Field="@(nameof(PurchaseOrder.Supplier.SupplierName))" Title="Supplier" />

</GridColumns>

</TelerikGrid>

The HTML and Telerik grids use the same data source and models. Many thanks

The

Data source uses ling query

1 Answer, 1 is accepted