public int serch(int value)
        {
            string query = "SELECT RentalNumber FROM rentalofrooms WHERE RentalNumber = value";
            cmd = new MySqlCommand(query, connection);

            connection.Open();
            value = Convert.ToInt32(cmd.ExecuteScalar());
            connection.Close();

            return value;
        }