Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Another Datarelation Question
Message
De
22/07/2003 10:24:32
Alvin Lourdes
Children and Youth Services Cluster
Toronto, Ontario, Canada
 
 
À
Tous
Information générale
Forum:
ASP.NET
Catégorie:
ADO.NET
Titre:
Another Datarelation Question
Divers
Thread ID:
00812359
Message ID:
00812359
Vues:
60
I am unsure on how to retrieve data from tables 2 tables
that are related through a relationship table....

This seems to confuse me...!

TableOne
--------
TableOneID
TableOneDesc

TableTwo
--------
TableTwoID
TableTwoDesc


TableOne_TableTwo_Relationship
------------------------------
TableOne_TableTwo_RelID
TableOneID
TableTwoID

I have related TableOne to TableOne_TableTwo_Relationship.
Then I have related TableTwo to
TableOne_TableTwo_Relationship.

I am unsure on how to traverse though the set
relationships to retrieve data. ie) I want to print out
all TableTwoDesc that have been related to a specific
TableOneID.

Thanks for your help,

Alvin
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform