How to retrieve from two tables with same foreign key repeated more than once?
Posted
by Sarenya
on Stack Overflow
See other posts from Stack Overflow
or by Sarenya
Published on 2010-06-05T11:45:50Z
Indexed on
2010/06/05
12:22 UTC
Read the original article
Hit count: 129
c#4.0
How to display the data of tables that are linked by a primary key and foreign key where the foreign key of the data repeats?
For ex. I have two tables, ParentTable
and Childtable
.
The primary key of ParentTable
acts as the foreign key of ChildTable
.
There are more than one record with same ParentId
in ChildTable
. How to retrieve them and display in a single Grid or List or any type of view?
© Stack Overflow or respective owner