I need help. I am a beginner and am developing attendance system. I got stuck on the way. Am having this problem. I have two templates fields for present/absent and authorised absent. Each I checked the checkbox named chckstatus to mark "P" for present and
unchecked for absent, the whole status column is populated with "P" for all students likewise for authorized absent. Each time I checked the checkbox named chckauthorized "O.D" suppose to be entered against a student associated with O.D but rather the whole
column is populated with O.D for all students.
I also want to generate weekly and monthly attendance against all students with total and percentage.
Each time I checked the checkbox named chckauthorized "O.D" suppose to be entered against a student associated with O.D but rather the whole column is populated with O.D for all students.
I'm not sure what is your problem, could you please describe you issue in detailed. and I suppose that
you want to submit the line of data when you click the checkbox? If so, you could modify and add some code snippet like below:
I also want to generate weekly and monthly attendance against all students with total and percentage.
I would suggest that you could calculate them with stored procedure after you save the attendance data, and retrieve the data from stored procedure. For more information about stored procedure, please refer to:
Member
4 Points
20 Posts
Students Attendance system using asp.net
Apr 07, 2016 01:09 PM|Allenteeno|LINK
Hi!
Compliments.
I need help. I am a beginner and am developing attendance system. I got stuck on the way. Am having this problem. I have two templates fields for present/absent and authorised absent. Each I checked the checkbox named chckstatus to mark "P" for present and unchecked for absent, the whole status column is populated with "P" for all students likewise for authorized absent. Each time I checked the checkbox named chckauthorized "O.D" suppose to be entered against a student associated with O.D but rather the whole column is populated with O.D for all students.
I also want to generate weekly and monthly attendance against all students with total and percentage.
Please help.
Below are my html and code behind:
Contributor
2570 Points
501 Posts
Re: Students Attendance system using asp.net
Apr 08, 2016 08:50 AM|Cole Wu|LINK
Hi Allenteeno,
I'm not sure what is your problem, could you please describe you issue in detailed. and I suppose that you want to submit the line of data when you click the checkbox? If so, you could modify and add some code snippet like below:
ASPX Page.
<asp:TemplateField HeaderText="AUTHORIZED ABSENT"> <ItemTemplate> <asp:CheckBox ID="ChckBoxAuthorized" runat="server" OnCheckedChanged="ChckBoxAuthorized_CheckedChanged" AutoPostBack="true" /> </ItemTemplate> <ItemStyle HorizontalAlign="Center" /> </asp:TemplateField>Code Behind.
protected void ChckBoxAuthorized_CheckedChanged(object sender, EventArgs e) { CheckBox chk = (CheckBox)sender; GridViewRow gr = (GridViewRow)chk.Parent.Parent; //your buniness logic here. //Response.Write(gr.Cells[0].Text + " --" + gr.Cells[1].Text + " --" + gr.Cells[2].Text + " --" + gr.Cells[3].Text); }I would suggest that you could calculate them with stored procedure after you save the attendance data, and retrieve the data from stored procedure. For more information about stored procedure, please refer to:
https://msdn.microsoft.com/en-sg/library/ms345415.aspx
Best regards,
Cole Wu