connecting multiple table records and display on one datagridview, is it possible?

[raokikun]

this are the details im gonna use

P_ID (a primary key)
student number
full name or firstname,lastname? (which is better)
year level
semester
course
subject code
subject description
grade
remarks

my system would be aimed to.. display the current grade of the student for example he is 4thyear and in semester 2 right now.

then there will be a button or any step that would display all his grade starting from 1st year sem1,sem2 up to his present grade

is it possible. can anyone help me? it will be a great help

feel free to give hints,tips and advice regarding database making

 

[jmcilhinney]

A DataGridView can display data from a single list so, if you have data coming from multiple tables, you must combine them into a single list at some point. You can either do that in the SQL code that gets the data from the database or you can use LINQ to combine multiple DataTables into a single list.

 

[raokikun]

thank you for the advice. good day