//private DataTable RetrieveDetail() //{ // DataTable dtAtt = new DataTable(); // string constring = ConfigurationManager.ConnectionStrings["dbx"].ConnectionString; // using (SqlConnection con = new SqlConnection(constring)) // { // using (SqlCommand cmd = new SqlCommand("SELECT * FROM Total_Attendance_db", sqlcon)) // { // con.Open(); // SqlDataAdapter reader = cmd.ExecuteReader(); // } // } // return dtAtt; //} private void button2_Click(object sender, EventArgs e) { this.Close(); AttendanceTable ATT = new AttendanceTable(); ATT.Show(); }
private void button1_Click(object sender, EventArgs e) { DialogResult dialog = MessageBox.Show("Are You Sure You Want To End Session?", "END SESSION?", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (dialog == DialogResult.Yes) { timer1.Stop(); sqlcon.Open(); string name = sessionName.Text; SqlCommand cmd = new SqlCommand(); cmd = new SqlCommand("UPDATE Total_Attendance_db set " + name + " = '0' WHERE " + name + " IS NULL ", sqlcon); cmd.ExecuteNonQuery(); sqlcon.Close(); this.Close(); AttendanceTable ATT = new AttendanceTable(); ATT.Show(); } else if (dialog == DialogResult.No) { MessageBox.Show("Ok, Continue..."); } }