/// <summary>
        /// This method charge all information of database in datagridview
        /// </summary>
        /// <param name="dataGridView1"></param>
        public void Cargar_Data_Grid(DataGridView dataGridView1)
        {
            DB_CRUD_Hoteles  db_hoteles = new DB_CRUD_Hoteles();
            NpgsqlConnection conn       = db_hoteles.Conexion();

            conn.Open();
            DataSet           dataSet = new DataSet();
            NpgsqlDataAdapter adapter = new NpgsqlDataAdapter(select, conn);

            adapter.Fill(dataSet, "Hoteles");
            dataGridView1.DataSource = dataSet.Tables[0];
            dataGridView1.Columns[0].HeaderCell.Value = "Identificacion Hotel";
            dataGridView1.Columns[1].HeaderCell.Value = "Nombre Hotel";
            dataGridView1.Columns[2].HeaderCell.Value = "Lugar";
            dataGridView1.Columns[3].HeaderCell.Value = "Habitaciones";
            dataGridView1.Columns[4].HeaderCell.Value = "Precio";
            DataGridViewImageColumn imgCol = new DataGridViewImageColumn();

            imgCol.HeaderText = "Foto Hotel";
            imgCol.Name       = "Foto Hotel";
            dataGridView1.Columns.Add(imgCol);
            dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
            //dataGridView1.Rows.RemoveAt((dataGridView1.RowCount - 1));
            conn.Close();
        }
        /// <summary>
        /// This method charge with countries the combobox
        /// </summary>
        /// <param name="cbPaises"></param>
        public void Cargar_Combobox(ComboBox cbPaises)
        {
            DB_CRUD_Hoteles  db_hoteles = new DB_CRUD_Hoteles();
            NpgsqlConnection conn       = db_hoteles.Conexion();
            NpgsqlDataReader dr         = null;

            try
            {
                conn.Open();
                cmd = new NpgsqlCommand("SELECT nombre_pais FROM paises;", conn);
                dr  = cmd.ExecuteReader();
                while (dr.Read())
                {
                    cbPaises.Items.Add(dr[0].ToString());
                }
                dr.Close();
                conn.Close();
            }
            catch (Exception ex)
            {
                dr.Close();
                conn.Close();
                Console.WriteLine("asa" + ex);
            }
        }
        /// <summary>
        /// This method charge the datagridview with places
        /// </summary>
        /// <param name="dataGridView1"></param>
        public void Cargar_Data_Grid(DataGridView dataGridView1)
        {
            DB_CRUD_Hoteles  db_hoteles = new DB_CRUD_Hoteles();
            NpgsqlConnection conn       = db_hoteles.Conexion();

            conn.Open();
            DataSet           dataSet = new DataSet();
            NpgsqlDataAdapter adapter = new NpgsqlDataAdapter(select, conn);

            adapter.Fill(dataSet, "Lugar");
            dataGridView1.DataSource = dataSet.Tables[0];
            dataGridView1.Columns[0].HeaderCell.Value = "Identificacion Lugar";
            dataGridView1.Columns[1].HeaderCell.Value = "Nombre Lugar";
            dataGridView1.Columns[2].HeaderCell.Value = "Pais";
            dataGridView1.AutoSizeColumnsMode         = DataGridViewAutoSizeColumnsMode.Fill;
            conn.Close();
        }
        /// <summary>
        /// This method charge with flights the datagridview
        /// </summary>
        /// <param name="dataGridView1"></param>
        public void Cargar_Data_Grid(DataGridView dataGridView1)
        {
            DB_CRUD_Hoteles  db_hoteles = new DB_CRUD_Hoteles();
            NpgsqlConnection conn       = db_hoteles.Conexion();

            conn.Open();
            DataSet           dataSet = new DataSet();
            NpgsqlDataAdapter adapter = new NpgsqlDataAdapter(select, conn);

            adapter.Fill(dataSet, "Lugar");
            dataGridView1.DataSource = dataSet.Tables[0];
            dataGridView1.Columns[0].HeaderCell.Value = "Identificacion Tarifa Vuelo";
            dataGridView1.Columns[1].HeaderCell.Value = "Ruta del vuelo";
            dataGridView1.Columns[2].HeaderCell.Value = "Precio";
            dataGridView1.AutoSizeColumnsMode         = DataGridViewAutoSizeColumnsMode.Fill;
            // dataGridView1.Rows.RemoveAt((dataGridView1.RowCount - 1));
            conn.Close();
        }
        /// <summary>
        /// This method search the flags of the countries
        /// </summary>
        /// <returns>And return them</returns>
        public List <object> Cargar_Bandera()
        {
            List <object>    list       = new List <object>();
            DB_CRUD_Hoteles  db_hoteles = new DB_CRUD_Hoteles();
            NpgsqlConnection conn       = db_hoteles.Conexion();
            NpgsqlDataReader dr;
            NpgsqlCommand    cmd;

            try
            {
                conn.Open();
                cmd = new NpgsqlCommand("SELECT foto_hotel FROM hoteles ORDER BY id_hotel ASC;", conn);
                dr  = cmd.ExecuteReader();
                if (dr.HasRows)
                {
                    while (dr.Read())
                    {
                        list.Add(dr.GetString(0));
                    }
                    return(list);
                }
                else
                {
                    return(null);
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex);
                return(null);
            }
            finally
            {
                conn.Close();
            }
        }