Click here to Skip to main content
15,924,901 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have a Table
table 1
ID CITY COUNTRY Details
1 2 1 details

table 2
ID City
1 Mumbai
2 Delhi

table 3
ID Country
1 India
2 Dubai

table 4
ID Table1_id City_id Country_id image
1 1 2 1 img1
2 1 2 1 img2
3 1 2 1 img3
4 1 2 1 img4

My question is how can i join all the tables and display main data once and image 4 times in my view or please give me some example through i can go and do correctly.+

What I have tried:

I have used ADO.NET approach and sql query but i know that is wrong so please help i want to display table1,table2,table3 data once in view and
table4 data 4times as there are 4 images in it
HELP
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900