private void comboBox3_SelectedIndexChanged(object sender, EventArgs e)
        {
            roomsConn roomsConn       = new roomsConn();
            String    selectedFaculty = rfaculty.Text.ToString();

            rName.DataSource = roomsConn.getRoomsByFaculty(selectedFaculty);
        }
        private void faculty_SelectedIndexChanged(object sender, EventArgs e)
        {
            roomsConn roomsConn       = new roomsConn();
            String    selectedFaculty = faculty.Text.ToString();

            assignRoom.DataSource = roomsConn.getRoomsByFaculty(selectedFaculty);
        }