private void button9_Click(object sender, System.EventArgs e) { Sec s = new Sec(); s.sql = "SELECT TOP 10 CariKodu,CariAdi FROM cari_tanim"; s.sql_orderby = " ORDER BY CariKodu"; s.tablename = "cari_tanim"; s.ShowDialog(); if (s.dr != null) { } }
private void button7_Click(object sender, System.EventArgs e) { Sec s=new Sec(); s.sql = "SELECT TOP 150 StokKodu,StokAdi FROM stok_tanim_ust (NOLOCK)"; s.sql_orderby=" ORDER BY StokKodu"; s.tablename="StokTanimlari"; s.ShowDialog(); if(s.dr!=null) { textBoxStok.Text=s.dr["StokKodu"].ToString(); textBoxStokAdi.Text = s.dr["StokAdi"].ToString(); } }
private void button6_Click(object sender, System.EventArgs e) { Sec s=new Sec(); s.sql="select MarkaKodu,MarkaAdi from marka_tanim (nolock) "; s.sql_orderby=" ORDER BY MarkaAdi"; s.tablename="marka_tanim"; s.ShowDialog(); if(s.dr!=null) { textBoxMarka.Text=s.dr["MarkaKodu"].ToString(); textBoxMarkaAdi.Text = s.dr["MarkaAdi"].ToString(); } }
private void button2_Click(object sender, System.EventArgs e) { Sec s=new Sec(); s.sql = "SELECT TOP 10 CariKodu,CariAdi FROM cari_tanim (NOLOCK)"; s.sql_orderby=" ORDER BY CariKodu"; s.tablename="cari_tanim"; s.ShowDialog(); if(s.dr!=null) { textBoxCari.Text=s.dr["CariKodu"].ToString(); textBoxCariAdi.Text = s.dr["CariAdi"].ToString(); } }
private void buttonStokKoduSec_Click(object sender, System.EventArgs e) { Sec s = new Sec(); s.sql = "SELECT TOP 20 StokKodu,StokAdi,StokAdi2,Diger1,Diger2 FROM stok_tanim_ust (nolock) "; s.tablename = "StokTanimlari"; s.sql_where = string.Format(" WHERE ( 1 = 1 ) "); if (s.ShowDialog() != DialogResult.OK) { return; } if (s.dr["StokKodu"] != DBNull.Value) { textBoxStokKodu.Text = s.dr["StokKodu"].ToString(); // if(s.dr["StokAdi"]!=DBNull.Value) // { // labelUrunAdi.Text=s.dr["StokAdi"].ToString(); // } } }