C# (CSharp) Hotel PriceForm.num Examples

Example #1

File: DB.cs Project: 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);
        }