6
Answers

Student attendance

Dharam Rai

Dharam Rai

9y
475
1
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. 
Answers (6)
0
Dharam Rai

Dharam Rai

NA 161 4.6k 9y
@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
Imtiyaz Ansari

Imtiyaz Ansari

NA 772 34.6k 9y
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
Dharam Rai

Dharam Rai

NA 161 4.6k 9y
@ 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
Sandy Surwase

Sandy Surwase

NA 293 21.8k 9y
how ur maintaing the section attendance all section in table else for every section diff table is.
0
Dharam Rai

Dharam Rai

NA 161 4.6k 9y
@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
Sandy Surwase

Sandy Surwase

NA 293 21.8k 9y
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