private void btn_MarkAttendance_Click(object sender, EventArgs e) { string attendance_Status = ""; int teacherId = Convert.ToInt32(data.Rows[0]["teacher_Id"].ToString()); int coureId = Convert.ToInt32(data.Rows[0]["course_Id"].ToString()); string teacherName = data.Rows[0]["teacher_Name"].ToString(); string courseName = data.Rows[0]["course_Name"].ToString(); int stuId = 0; string stuName = ""; int iter = 0; foreach (object item in checkedListBox_Attendance.Items) { if (checkedListBox_Attendance.CheckedItems.Contains(item)) { attendance_Status = "Present"; } else { attendance_Status = "Absent"; } stuId = Convert.ToInt32(data.Rows[iter]["student_Id"].ToString()); stuName = data.Rows[iter]["student_Name"].ToString(); iter++; mysql.AttendanceInsert(stuId, teacherId, coureId, stuName, teacherName, courseName, dateNow, attendance_Status); } label_Message.ForeColor = Color.Green; label_Message.Text = "Attendance Marked."; label_Message.Show(); }