private void button4_Click(object sender, EventArgs e) { this.Hide(); studetails s1 = new studetails(); s1.Show(); }
// edit delete private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { try { conn.Open(); if (e.RowIndex == dataGridView1.NewRowIndex || e.RowIndex < 0) { return; } //Check if click is on specific column if (e.ColumnIndex == dataGridView1.Columns["DeleteButton"].Index) { int index = e.RowIndex; int ID = Convert.ToInt32(dataGridView1.Rows[index].Cells[3].Value.ToString()); string delete3 = string.Format("DELETE FROM GroupStudent WHERE StudentId = '{0}'", ID); SqlCommand del3 = new SqlCommand(delete3, conn); int k = del3.ExecuteNonQuery(); string delete1 = String.Format("DELETE FROM Student WHERE Id = '{0}'", ID); SqlCommand de11 = new SqlCommand(delete1, conn); int i = de11.ExecuteNonQuery(); string delete2 = string.Format("DELETE FROM Person WHERE Id = '{0}'", ID); SqlCommand del2 = new SqlCommand(delete2, conn); int j = del2.ExecuteNonQuery(); // to check if the student is registered or not if (i >= 1 && j >= 1) { MessageBox.Show(" Student Deleted "); this.Refresh(); } else { MessageBox.Show(" Student not Deleted "); } this.Refresh(); Refresh(); this.Hide(); student ss = new student(); ss.Show(); } else if (e.ColumnIndex == dataGridView1.Columns["EditButton"].Index) { int indexx = e.RowIndex; IDD = Convert.ToInt32(dataGridView1.Rows[indexx].Cells[3].Value.ToString()); panel3.Show(); button5.Hide(); button6.Show(); string fn = "SELECT FirstName FROM Person WHERE Id = '" + IDD + "' "; SqlCommand fnn = new SqlCommand(fn, conn); fnn.ExecuteNonQuery(); string first = Convert.ToString(fnn.ExecuteScalar()); textBox1.Text = first; string ln = "SELECT LastName FROM Person WHERE Id = '" + IDD + "' "; SqlCommand lnn = new SqlCommand(ln, conn); lnn.ExecuteNonQuery(); string last = Convert.ToString(lnn.ExecuteScalar()); textBox2.Text = last; string con = "SELECT Contact FROM Person WHERE Id = '" + IDD + "' "; SqlCommand cont = new SqlCommand(con, conn); cont.ExecuteNonQuery(); string contact = Convert.ToString(cont.ExecuteScalar()); textBox3.Text = contact; string em = "SELECT Email FROM Person WHERE Id = '" + IDD + "' "; SqlCommand emi = new SqlCommand(em, conn); emi.ExecuteNonQuery(); string email = Convert.ToString(emi.ExecuteScalar()); textBox4.Text = email; string regno = "SELECT RegistrationNo FROM Student WHERE Id = '" + IDD + "' "; SqlCommand reg = new SqlCommand(regno, conn); reg.ExecuteNonQuery(); string rollno = Convert.ToString(reg.ExecuteScalar()); textBox5.Text = rollno; string gen = "SELECT Gender FROM Person WHERE Id = '" + IDD + "' "; SqlCommand gender = new SqlCommand(gen, conn); gender.ExecuteNonQuery(); int genn = Convert.ToInt32(gender.ExecuteScalar()); string designn = "SELECT Value FROM Lookup WHERE Category= 'GENDER' AND Id ='" + genn + "' "; SqlCommand InvAmountcom = new SqlCommand(designn, conn); string mf = Convert.ToString(InvAmountcom.ExecuteScalar().ToString()); comboBox1.Text = mf; } else if (e.ColumnIndex == dataGridView1.Columns["DetailsButton"].Index) { this.Hide(); studetails s1 = new studetails(); s1.Show(); } conn.Close(); } catch (Exception a) { MessageBox.Show(a.Message); } }