i m making website of college in which i have two show the all data of student(student name, course from student table, and faculity from teacher table and result ) after he login his account
i have 3 table in sql one is student which have student id, name and course etc.
,teacher which have course, faculity name etc.
and result which have student id, course and marks etc.
what the coding in asp.net to show the data. so that its show the data of particular student after login.
should i make a store procedure if yes how to compare it with username or sumthing else thx in advance