[Solved] Parent - Child Relationship

[aung maw]

Hi, I have a orders  and orderdetails table.  I can use hierarchical representation of related data tables and that works fine.  But  how can i display one of the fields from orderdetails column in orders grid column.  for example, order id 1 has 3 order details.  so i want to display orderid, orderdetail1.orderdate, orderdetail2.orderdate, orderdetail3.date in a sigle grid without nesting.

please let me know.
thanks,

[Shinu]

Hi,

Use a join/union clause in your select statement to combine the data residing in different datatables(Order and Orderdetails) and then include the resulting fields in the RadGrid.

Shinu