private void button1_Click(object sender, EventArgs e) { AllStudentInfo std = new AllStudentInfo(); this.Hide(); std.Show(); }
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { try { SqlConnection con = new SqlConnection(conStr); con.Open(); if (e.RowIndex > -1) { if (e.ColumnIndex == 0) { EditStudent edit = new EditStudent(); edit.txt_id.Text = this.dataGridView1.CurrentRow.Cells[2].Value.ToString(); edit.txtfname.Text = this.dataGridView1.CurrentRow.Cells[4].Value.ToString(); edit.txt_lname.Text = this.dataGridView1.CurrentRow.Cells[5].Value.ToString(); edit.txt_contact.Text = this.dataGridView1.CurrentRow.Cells[6].Value.ToString(); edit.txt_email.Text = this.dataGridView1.CurrentRow.Cells[7].Value.ToString(); edit.ShowDialog(); } else if (e.ColumnIndex == 1) { DataGridViewRow row = this.dataGridView1.Rows[e.RowIndex]; string t = "DELETE FROM GroupStudent where StudentId = '" + row.Cells[2].Value + "';"; string q = "DELETE FROM Student where Id = '" + row.Cells[2].Value + "';"; string p = "DELETE FROM Person where Id = '" + row.Cells[2].Value + "';"; // string t = "DELETE FROM where Id = '" + row.Cells[2].Value + "';"; SqlCommand cmt = new SqlCommand(t, con); cmt.ExecuteNonQuery(); SqlCommand cm = new SqlCommand(q, con); cm.ExecuteNonQuery(); SqlCommand cmd = new SqlCommand(p, con); cmd.ExecuteNonQuery(); MessageBox.Show("Congrats! Record Recorded"); SqlDataAdapter sql = new SqlDataAdapter("SELECT Person.Id, Student.RegistrationNo, Person.FirstName, Person.LastName, Person.Contact,Person.Email, Person.DateOfBirth, Person.Gender from Student JOIN Person ON Student.Id = Person.Id;", con); DataTable datatab = new DataTable(); sql.Fill(datatab); dataGridView1.DataSource = datatab; con.Close(); } AllStudentInfo std = new AllStudentInfo(); this.Hide(); std.Show(); } }catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btn_addstd_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(conStr); con.Open(); if (con.State == ConnectionState.Open) { string p = "INSERT INTO Student(Id, RegistrationNo)VALUES((SELECT MAX(Id) FROM Person),('" + (txt_regno.Text).ToString() + "'));"; SqlCommand cmd = new SqlCommand(p, con); cmd.ExecuteNonQuery(); MessageBox.Show("Data Inserted Successfully"); } AllStudentInfo std = new AllStudentInfo(); this.Hide(); std.Show(); }