How to retrieve from two tables with same foriegn 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 11:52 UTC
Read the original article Hit count: 108

Filed under:

How to display the datas of tables, that are linked by a primay key and foriegn key, where the foriegn key of the data repeats? For ex. I have two tables, ParentTable and Childtable. The primarykey of the Parent table acts as the foriegn key of the Child table. There are more than one record with same ParentId in Child table. How to retrieve them and display in a single Grid or List or any type of view?

© Stack Overflow or respective owner

Related posts about c#4.0