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

Value in master table retrieved using key to detail table

2 Answers 33 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Laura
Top achievements
Rank 1
Laura asked on 29 Aug 2008, 06:00 PM
Would I be able to get an example of the following:

I have a master table called contacts. One field is contact_type_id. In the master table I would like to display the contact_type_name which resides in the contact_type table. So rather than just displaying the contact_type_id which is in the master contacts table, I would like to show the name of the contact type to be more explicit.

Thanks in advance,
Laura

2 Answers, 1 is accepted

Sort by
0
Shinu
Top achievements
Rank 2
answered on 01 Sep 2008, 05:22 AM
Hi Laura,

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.

Thanks
Shinu
0
rtk
Top achievements
Rank 1
answered on 05 Nov 2008, 01:21 PM
Is there a way to do this without joining the tables in sql.

My datalayer only allows me to get one datatable with contact_id and one datatable with contact_name. Can i put this to datatable in a dataset and join them there?? And somehow display the name instead of the id in the grid.
Tags
Grid
Asked by
Laura
Top achievements
Rank 1
Answers by
Shinu
Top achievements
Rank 2
rtk
Top achievements
Rank 1
Share this question
or