Student attendance

Question

Dear all genius please help me with this, I am developing a school management project where I have to maintain student attendance register. I have a student record in tbl_Student with PK as StudentID, and attendance record in tbl_Attendance with FK as StudentID. The problem is instead of entering student attendance status manually (Present/Absent/Sick), I want it to do automatically, for if I Select date and present status as Present then it should enter Present in all the records and for absent or other could be set manually one by one.

My table description:

tbl_Student : StudentID(PK), student name, Student class.

tbl_Attendacne: Attendacne_ID, StudentID(FK to tblStudent), Date, Status(Present/Absent/Sick)

I have been googling but could not get any, please help you there genius. Thanks in advance.

Dharam Rai · Answer

@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?

Imtiyaz Ansari · Answer

Hello Dharam can you try this way ....!!!! my one of project like similar task then ..create a page above few searching criteria college name coursebranch 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 ....

Dharam Rai · Answer

@ 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.

Sandy Surwase · Answer

how ur maintaing the section attendance all section in table else for every section diff table is.

Dharam Rai · Answer

@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. :(

Sandy Surwase · Answer

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(PresentstudentId) values(@attende@studentId); go