Hello,
I am trying to display a list of product in a RadGrid. Product belongs to multiple categories. Product to the categories relatioships are kept in a separate table. So I got three tables: Product, Category and ProductCategory. I want to display a list of products in a RadGrid along with a templateColumn which lists the product's categories.
I tried various different methods such as DetailTables, TemplateColumn with a child RadGrid etc, but unable to get the product categories displayed in a template column. Any assistance you could provide is greatly appreciated.
Thanks,
Buddha Manandhar
I am trying to display a list of product in a RadGrid. Product belongs to multiple categories. Product to the categories relatioships are kept in a separate table. So I got three tables: Product, Category and ProductCategory. I want to display a list of products in a RadGrid along with a templateColumn which lists the product's categories.
I tried various different methods such as DetailTables, TemplateColumn with a child RadGrid etc, but unable to get the product categories displayed in a template column. Any assistance you could provide is greatly appreciated.
Thanks,
Buddha Manandhar
1 Answer, 1 is accepted
0
Shinu
Top achievements
Rank 2
Rank 2
answered on 23 Feb 2009, 11:23 AM
Hi Buddha,
You can use use a join/union clause in your select statement to combine the data residing in different datatables and then include the resulting fields in the RadGrid.
Shinu
You can use use a join/union clause in your select statement to combine the data residing in different datatables and then include the resulting fields in the RadGrid.
Shinu