private void buttonupdate_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection("Data Source=DESKTOP-5QHHH7M;Initial Catalog=HOSTEL;Integrated Security=True"); con.Open(); String query = "UPDATE UNIVERSITY SET UNI_NAME='" + textBox1.Text + "', EMAIL='" + textBox3.Text + "',PHONE_NO='" + textBox4.Text + "',ADDRESS='" + textBox2.Text + "' where UNI_ID='" + UNI_ID + "'"; SqlCommand runquery = new SqlCommand(query, con); runquery.ExecuteNonQuery(); MessageBox.Show("successful"); this.Close(); var asha = new Form7(); asha.Show(); }
private void buttondelete_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection("Data Source=DESKTOP-5QHHH7M;Initial Catalog=HOSTEL;Integrated Security=True"); con.Open(); String query = "DELETE FROM UNIVERSITY WHERE UNIVERSITY.UNI_ID='" + UNI_ID + "'"; SqlCommand runquery = new SqlCommand(query, con); runquery.ExecuteNonQuery(); MessageBox.Show(" Deletion finished successfully"); this.Close(); var asha = new Form7(); asha.Show(); }
private void vIEWUNIVERSITYToolStripMenuItem_Click(object sender, EventArgs e) { var we = new Form7(); we.Show(); }