private void gridU() { lvUrunler.Items.Clear(); cBaglanti bgl = new cBaglanti(); MySqlConnection con = new MySqlConnection(bgl.baglanti); MySqlCommand kmt = new MySqlCommand("select * from kategori", con); List <cKategori> ktgr = new List <cKategori>(); con.Open(); MySqlDataReader drKategori = kmt.ExecuteReader(); while (drKategori.Read()) { cKategori kt = new cKategori(); kt.Id = Convert.ToInt32(drKategori["Id"]); kt.adi = drKategori["adi"].ToString(); ktgr.Add(kt); } con.Close(); MySqlCommand cmd = new MySqlCommand("select * from urunler", con); con.Open(); MySqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { ListViewItem item = new ListViewItem(dr["id"].ToString()); item.SubItems.Add(dr["adi"].ToString()); item.SubItems.Add(dr["fiyati"].ToString()); item.SubItems.Add(cozum(dr["kId"].ToString())); //int a = Convert.ToInt32(dr["kId"]); //con.Close(); //MySqlCommand cmda = new MySqlCommand("select adi from kategori where Id=" + a, con); //con.Open(); //MySqlDataReader dra = cmda.ExecuteReader(); //con.Close(); //string b = dra.ToString(); //item.SubItems.Add(b); lvUrunler.Items.Add(item); } con.Close(); }
private void grid() { if (this.InvokeRequired) { this.Invoke(new DelegateStandardPattern(grid)); } else { tutar(); label2.Text = "0₺"; lblMasa.Text = cBilgilendirme._buttonText; cBaglanti bgl = new cBaglanti(); MySqlConnection connet = new MySqlConnection(bgl.baglanti); MySqlCommand kmt = new MySqlCommand("select * from kategori", connet); List <cKategori> ktgr = new List <cKategori>(); connet.Open(); MySqlDataReader drKategori = kmt.ExecuteReader(); while (drKategori.Read()) { cKategori kt = new cKategori(); kt.Id = Convert.ToInt32(drKategori["Id"]); kt.adi = drKategori["adi"].ToString(); ktgr.Add(kt); } cmbKatagori.DataSource = ktgr; cmbKatagori.DisplayMember = "adi"; connet.Close(); MySqlCommand cmd = new MySqlCommand("select u.id,u.adi,u.fiyati from urunler u, siparis s where s.masa_id=" + cBilgilendirme._buttonId + " and u.id=s.urun_id ", connet); connet.Open(); MySqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { ListViewItem item = new ListViewItem(dr["id"].ToString()); item.SubItems.Add(dr["adi"].ToString()); item.SubItems.Add(dr["fiyati"].ToString()); lvSiparis.Items.Add(item); } tutar(); } }