How to create a custom filter template RRS feed

  • Question

  • User1929428035 posted

    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.

    Please help.

    Wednesday, May 15, 2013 5:02 PM


All replies