예제 #1
0
파일: DB.cs 프로젝트: DotsenkoKate/Hotel
        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);
        }