How do I reference a related table column?

[Dave]

I have a grid tied to an EntityDataSource and can show the columns fine. One of the columns is a guid and I want to show a related table value instead of the guid. I include the related table in the EDS definitions. How do I refernce in the column? The following does not work. Thanks.

<telerik:GridBoundColumn DataField="it.Facility.FacilityName" DataType="System.String"

    FilterControlAltText="Filter Facility column" ReadOnly="True"

    HeaderText="Facility" SortExpression="Facility"

    UniqueName="Facility">
</telerik:GridBoundColumn>

 

[Dave]

I'm pretty sure all I need to do is drop the "it." then I can navigate but am unable to try this right now...

[Genti]

Hi Dave,

Thank you for contacting us.

If you are using an EntityDataSource control than you can achieve that kind of referencing if you set the select command in the following:

Select="it.[OrderID], it.Customer.[ContactName]">

And then the BoundColumn would be:

<telerik:GridBoundColumn DataField="ContactName" HeaderText="Name" UniqueName="ContactName" />

Otherwise, if you set the DataSource on the GridNeedDataSource event, then you need to make the referenced table columns public to the grid in the following:

protected void RadGrid1_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)
{
    var lines = from o in DbContext.Orders
                select new
                {
                    OrderID = o.OrderID,
                    ContactName = o.Customer.ContactName
                };

    RadGrid1.DataSource = lines;
}

I am also attaching a sample solution that makes use of the Northwind database.


Hope this helps.

Greetings,
Genti
the Telerik team