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);
}