I have a student page where students are allowed to add tachers to their profile, so the query below does it for me but i cant display the number of
teachers added by the students, So the Status displayes the count each time a student adds tearchers username to hiis/her profile. So the question is
How do i display the total count of Status added by each student.
Select * FROM [Files] where studentusername IN (SELECT TeacherUserName as name FROM CourseStatus WHERE StudentUserName=@TeacherUserName AND Status=1 )
Example
ID StudentUserName TeachersUserName Status
--------------------------------------------------------------------------
1 MaryKay22 Brown44 1
--------------------------------------------------------------------
2 MaryKay22 Kane66 1
-------------------------------------------------------------------
3 Steve33 Brown44 1
-------------------------------------------------------------
4 Steve33 Paul77 1
---------------------------------------------------------------------
5 MaryKay22 James90 1
So with this query below MarKay22 total Status count is = 3
while steve Status is =2
Select * FROM [Files] where studentusername IN (SELECT TeacherUserName as name FROM CourseStatus WHERE StudentUserName=@TeacherUserName AND Status=1 )
So how will i display the count on page using FormView, just the Status total count of the user
