public void sorguyerleştir() { adp = new OleDbDataAdapter(GENELSORGU(sehir, yildiz, fiyat, merkez, wifi, havuz, kahvalti, otelsirala), bag); DataTable tablo = new DataTable(); adp.Fill(tablo); flowLayoutPanel1.Controls.Clear(); for (int i = 0; i < tablo.Rows.Count; i++) { dr = tablo.Rows[i]; my = new MyOtel(); my.Name = dr["Otel_Ad"].ToString(); my.Controls["btnGoster"].Name = dr["Otel_ID"].ToString(); my.Controls["lblOtelAdi"].Text = dr["Otel_Ad"].ToString(); my.Controls["pbresim"].BackgroundImage = Properties.Resources.mylogo; my.Controls["lbladres"].Text = dr["Acik_Adres"].ToString(); my.Controls["lblfiyat"].Text = dr["Fiyat"].ToString() + " ₺"; my.Controls["lbloy"].Text = "Değerlendirme : " + dr["Oy"].ToString(); PictureBox pb = (PictureBox)my.Controls["pbyildiz"]; pb.ImageLocation = "YildizResim\\" + dr["Yildiz_Sayisi"] + ".png"; otel_id = Convert.ToInt16(dr["Otel_ID"]); my.degerdurum(my.lbldeger, my.lbloy, Convert.ToInt16(dr["Oy"])); ResimGetir(dr["Otel_Ad"].ToString(), (PictureBox)my.Controls["pbresim"]); flowLayoutPanel1.Controls.Add(my); } GC.Collect(); GC.WaitForPendingFinalizers(); tablo.Dispose(); tablo = null; adp.Dispose(); adp = null; }
private void P_Click(object sender, EventArgs e) { ((PopupNotifier)sender).Hide(); flowLayoutPanel1.Controls.Clear(); adp = new OleDbDataAdapter("SELECT * FROM FIRSAT INNER JOIN OTEL ON FIRSAT.Otel_ID = OTEL.Otel_ID WHERE Otel_Ad ='" + ad + "'", FırsatBul.bag); DataTable tablo = new DataTable(); adp.Fill(tablo); dr = tablo.Rows[0]; my = new MyOtel(); my.Name = dr["Otel_Ad"].ToString(); my.Controls["lbleski"].Visible = true; my.Controls["lbleski"].Text = dr["Eski_Fiyat"].ToString() + " ₺"; my.Controls["lblyuzde"].Visible = true; int yuzde = 100 - Convert.ToInt16(Convert.ToDouble(dr["Yeni_Fiyat"]) / ((Convert.ToDouble(dr["Eski_Fiyat"]) / 100))); my.Controls["lblyuzde"].Text = "- % " + yuzde.ToString(); my.Controls["btnGoster"].Name = dr["OTEL.Otel_ID"].ToString(); my.Controls["lblOtelAdi"].Text = dr["Otel_Ad"].ToString(); my.Controls["pbresim"].BackgroundImage = Properties.Resources.mylogo; my.Controls["lbladres"].Text = dr["Acik_Adres"].ToString(); my.Controls["lblfiyat"].Text = dr["Yeni_Fiyat"].ToString() + " ₺"; PictureBox yldzresim = (PictureBox)my.Controls["pbyildiz"]; yldzresim.ImageLocation = "YildizResim\\" + dr["Yildiz_Sayisi"] + ".png"; // PictureBox otelresim = (PictureBox)my.Controls["pbresim"]; my.degerdurum(my.lbldeger, my.lbloy, Convert.ToInt16(dr["Oy"])); ResimGetir(dr["Otel_Ad"].ToString(), (PictureBox)my.Controls["pbresim"]); flowLayoutPanel1.Controls.Add(my); }