DataSet, GridView DataBinding to Parent Information

[David]

Hi,

I have setup a dataSet with 3 tables Locations,Customers and Orders. I have setup 3 relations "Locations to Customers" , "Locations to Orders" and "Customers to Orders"

I have a form that has two GridViews one to show All the Customers and one to show the Selected Customers Orders.

I have done this by: 

MainForm.DataSource = FormData;
MainForm.DataMember = "Customers";

SubForm.DataSource = FormData;
SubForm.DataMember = "Customers.Customers_Orders";

Is there anyway I can bind a column to the Locations Description from the Locations table via the  "Locations to Customers"/"Locations to Orders" in the relative grids? 

[Julian Benkov]

Hello David,

Thank you for writing.

You can use the GridViewComboBoxColumn to achieve the desired behavior. Simply bind the column to your Locations data. More information about GridViewComboBoxColumn and binding you can find in our online documentation.

I hope this helps. Feel free to ask if you have any additional questions. 

All the best, Julian Benkov
the Telerik team