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: 181
        
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