void siparis() { baglanti.Open(); try { komut = new OleDbCommand("Select * from ecz_sipar where istek=true", baglanti); OleDbDataReader dr = komut.ExecuteReader(); while (dr.Read()) { String a = dr["eczane_adi"].ToString(); // comboBox1.Text = dr["eczane_adi"].ToString(); ilal.Hide(); ilsatdurumu.Hide(); kasadurum.Hide(); ilsat.Show(); Bilgi.Hide(); eczsilgb.Hide(); ecz_ekle.Hide(); eczduzenle.Hide(); ilacbil.Show(); this.ecz_siparTableAdapter.Fill(this.girisDataSet.ecz_sipar); this.eczaneTableAdapter.Fill(this.girisDataSet.eczane); this.ilacTableAdapter.Fill(this.girisDataSet.ilac); } } catch (Exception) { } baglanti.Close(); }
private void EczaDeposu1_Load(object sender, EventArgs e) { // TODO: This line of code loads data into the 'girisDataSet.kasa1' table. You can move, or remove it, as needed. this.kasa1TableAdapter.Fill(this.girisDataSet.kasa1); // TODO: This line of code loads data into the 'girisDataSet.durum' table. You can move, or remove it, as needed. this.durumTableAdapter.Fill(this.girisDataSet.durum); // TODO: This line of code loads data into the 'girisDataSet.ecz_sipar' table. You can move, or remove it, as needed. this.ecz_siparTableAdapter.Fill(this.girisDataSet.ecz_sipar); this.eczaneTableAdapter.Fill(this.girisDataSet.eczane); this.ilacTableAdapter.Fill(this.girisDataSet.ilac); // TODO: This line of code loads data into the 'girisDataSet.eczane' table. You can move, or remove it, as needed. // TODO: This line of code loads data into the 'girisDataSet.eczane_sip' table. You can move, or remove it, as needed. // TODO: This line of code loads data into the 'girisDataSet.ilac' table. You can move, or remove it, as needed. // TODO: This line of code loads data into the 'girisDataSet.eczane' table. You can move, or remove it, as needed. timer1.Interval = 10000; timer1.Start(); ilal.Hide(); ilsat.Hide(); Bilgi.Hide(); eczsilgb.Hide(); ecz_ekle.Hide(); eczduzenle.Hide(); eczkulgenel.Hide(); ilacbil.Hide(); ilsatdurumu.Hide(); kasadurum.Hide(); }
private void karZararToolStripMenuItem_Click(object sender, EventArgs e) { kasadurum.Show(); ilal.Hide(); ilsat.Hide(); Bilgi.Hide(); eczsilgb.Hide(); ecz_ekle.Hide(); eczduzenle.Hide(); eczkulgenel.Hide(); ilacbil.Hide(); ilsatdurumu.Hide(); }
private void goster_Click(object sender, EventArgs e) { ilacbil.Show(); ilal.Hide(); ilsat.Show(); Bilgi.Hide(); eczsilgb.Hide(); ecz_ekle.Hide(); eczduzenle.Hide(); eczkulgenel.Hide(); ilsatdurumu.Hide(); kasadurum.Hide(); /* siparis();*/ }
private void eczaneEkleToolStripMenuItem_Click(object sender, EventArgs e) { kasadurum.Hide(); ilsatdurumu.Hide(); ilacbil.Hide(); ilal.Hide(); ilsat.Hide(); Bilgi.Hide(); eczsilgb.Hide(); ecz_ekle.Show(); eczduzenle.Hide(); eczkulgenel.Show(); this.ecz_siparTableAdapter.Fill(this.girisDataSet.ecz_sipar); this.eczaneTableAdapter.Fill(this.girisDataSet.eczane); this.ilacTableAdapter.Fill(this.girisDataSet.ilac); }