0
@Imtiyaz can I mange it daily with date? And in grid view do I have to get checkbox column and date column from the student table only?
0
Hello Dharam
can you try this way ....!!!!
my one of project like similar task then ..create a page above few searching criteria
college name ,course,branch ,and section then search ..all record bind a grid view with check box ...
whose student are not present unchecked to the checked box and then save ....
present student flag true and absence student flag false ....this way can you manage ....
0
@ Sandy, I got three table : tbl_Section, tbl_Student and tbl_Attendance. Student in tbl_Student are link with tbl_Section by the SectionID (FK in tbl_Student and PK in tbl_Section), also Student is linked with tbl_Attendacne by StudentID (FK in tbl_Attendacne and PK in tbl_Student).
I am maintaining only one table for all the section.
Thanks for the reply. Looking forward to hear from you.
0
how ur maintaing the section attendance all section in table else for every section diff table is.
0
@Sandy thanks for the reply, but I am looking for something different. For Eg. there are 10 sections and in each section there are 50 students, now it is not possible for operator to go one by one and set attendance status manually for all the 10 section across 500 students which is simply impossible. I am looking for a click event when the button is clicked then, the attendance status of each of the student in all the section with date will be mark as PRESENT and now the operator can manually go and change the status of ABSENT student, which will be few or may be no absentees.
Thanks in advance if any genius out there can help me with this. :(
0
Hello when user is login take 3 input userid password and present status from dropdown if everything k then call the store procedure like this
create proc autoAttendance(@studentId int,@attende int)
as
insert into tbl_Attendance(Present,studentId) values(@attende,@studentId);
go