private void button5_Click(object sender, EventArgs e) { this.Hide(); Class_Attendence a = new Class_Attendence(); a.Show(); }
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString() == "Edit") { dash.classAttendence = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[0].Value); this.Hide(); Class_Attendence addAttendence = new Class_Attendence(); addAttendence.Show(); } if (dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString() == "Delete") { int ClassAttendence = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[0].Value); if (MessageBox.Show("Do you want to delete " + dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString() + "?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { SqlConnection connect = new SqlConnection(cnn); connect.Open(); SqlCommand command = new SqlCommand("DELETE FROM [StudentAttendance] WHERE AttendanceId = '" + ClassAttendence + "'", connect); SqlCommand command1 = new SqlCommand("DELETE FROM ClassAttendance WHERE Id = '" + ClassAttendence + "'", connect); command.ExecuteNonQuery(); command1.ExecuteNonQuery(); connect.Close(); this.classAttendanceTableAdapter.Fill(this.projectBDataSet1.ClassAttendance); } } }