private void btn_MarkAttendance_Click(object sender, EventArgs e) { string attendance_Status = ""; int attendance_Id = 0; int iter = 0; foreach (object item in checkedListBox_Attendance.Items) { if (checkedListBox_Attendance.CheckedItems.Contains(item)) { attendance_Status = "Present"; } else { attendance_Status = "Absent"; } attendance_Id = Convert.ToInt32(data.Rows[iter]["attendance_Id"].ToString()); iter++; mysql.AttendanceUpdate(attendance_Id, attendance_Status); } label_Message.ForeColor = Color.Green; label_Message.Text = "Attendance Edited."; label_Message.Show(); }