Last post May 16, 2013 06:57 AM by mr41971
May 15, 2013 05:02 PM|mr41971|LINK
I am building a Student Information System which allows different roles to log in. When a Teacher logs in I want them to be able to access only students in the class that they teach. A Class may have one or more Students. When the Teacher accesses the StudentAttendance
"gridview" which does not have a ClassID I want to show only Students who belong to the Class that the Teacher teaches. The StudentAttendance table has the following fields: ID, StudentID, Date, Present, Late. I have a TeacherClass table: ID, TeacherID, ClassID.
Also There is a ClassStudent table: ID, ClassID, StudentID, AcademicYear. So via SQL I can easily determine the Students in a specific class taught by a specific Teacher.
May 16, 2013 01:24 AM|catherine sea|LINK
You can check out the blog article below:
May 16, 2013 06:57 AM|mr41971|LINK