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

Multi-Source RadGrid?

1 Answer 34 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Guenni
Top achievements
Rank 1
Guenni asked on 08 Sep 2008, 08:16 PM
Hello,

I binded my RadGrid to a Aspdatasource in designview. The columns are: Student_ID, Sport_ID
A student belongs to a sport. Is there a design-way i can add a column displaying the Sportname, instead of the ID. So actually retrieving data from the Sport table and combining it with other table data.(multi-source grid?)

I assume i need to place another datasource for Sport and then binding it to the new added column.

Your help is highly appreciated

~Guen~

1 Answer, 1 is accepted

Sort by
0
Shinu
Top achievements
Rank 2
answered on 09 Sep 2008, 07:35 AM
Hi,

 If the data resides in different datatables, you can use a join/union clause in your select statement and then include the resulting fields in the RadGrid.
http://support.microsoft.com/kb/326080

Thanks
Shinu.
Tags
Grid
Asked by
Guenni
Top achievements
Rank 1
Answers by
Shinu
Top achievements
Rank 2
Share this question
or