How to create a custom filter template

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.

Answer 1

User-585189074 posted

You can check out the blog article below:
http://www.olegsych.com/2010/07/understanding-aspnet-dynamic-data-filter-templates/
 

Answer 2

User1929428035 posted

Thank you.