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 stu_room SET room_id ='" + txtroomno.Text + "',stu_id ='" + txtSTUID.Text + "' where stu_room_id = '" + stu_room_id + "'"; SqlCommand cmd = new SqlCommand(query, con); cmd.ExecuteNonQuery(); string query1 = "UPDATE ROOM SET room_type = '" + TXTTYPE.Text + "',price = '" + TXTPRICE.Text + "' where ROOM_ID ='" + ROOM_ID + "'"; SqlCommand CMD1 = new SqlCommand(query1, con); CMD1.ExecuteNonQuery(); string query2 = "UPDATE STUDENT SET F_NAME = '" + TXTNAME.Text + "' WHERE STU_ID = '" + STU_ID + "'"; SqlCommand CMD2 = new SqlCommand(query2, con); CMD2.ExecuteNonQuery(); { MessageBox.Show("Updation done succesfully"); this.Hide(); Rooms_not_occupied de = new Rooms_not_occupied(); this.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 stu_room WHERE stu_room.room_id='" + txtroomno.Text + "'"; SqlCommand runq1 = new SqlCommand(query, con); runq1.ExecuteNonQuery(); { MessageBox.Show("deletion done Successifully"); this.Hide(); Rooms_not_occupied sa = new Rooms_not_occupied(); sa.Show(); } }
private void StatusBarToolStripMenuItem_Click(object sender, EventArgs e) { Rooms_not_occupied r = new Rooms_not_occupied(); r.Show(); }
private void rOOMOCCUPIEDToolStripMenuItem_Click(object sender, EventArgs e) { Rooms_not_occupied da = new Rooms_not_occupied(); da.Show(); }