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~
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
0
Shinu
Top achievements
Rank 2
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.
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.