How to display records from a junction table in vb.net application.

See more:

VB

i have two tables, Subjects and Departments, with a many to many relationship. The junction table is called Departments_Subjects_junction. i use sql server dbms.

Subjects:
subjects_id(primary key)
subject_name


Departments:
department_id(primary key)
department_name

Departments_Subjects_junction:
subject_id(primary key)
department_id(primary key)


I am able to store data in all the three tables.

Now in my v.b application i want to display the records for the user to see.
For eg, the user must see the list of all subjects for each department.
Something like this:

DepartmentA- Subject1, subject2, subject3,Subject4
DepartmentB- subject2, subject3, subject5
DeparmtentC- subject1, subject3, subject6.


How can i implement this in the best manner?using datagrid or listview or somethingelse? Please help. Thanks.