public String PriceCurrentRoom() { openConnection(); String id = PriceForm.num(); string query = "SELECT `Цена за ночь` FROM `номер` WHERE Номер =" + id; MySqlCommand command = new MySqlCommand(query, connection); MySqlDataReader reader = command.ExecuteReader(); String data = ""; while (reader.Read()) { data = reader[0].ToString(); } reader.Close(); closeConnection(); return(data); }