public void loadData() { listDTrans.Items.Clear(); submit.IsEnabled = false; try { conn.Open(); string query = "select distinct h.kode_htrans " + "from htrans h, dtrans d, mh_user u, mh_produk p " + "where h.kode_htrans = d.fk_htrans and d.status < 2 and d.reportB = 0 and d.fk_produk = p.kode_produk and p.fk_penjual = u.kode_user and u.kode_user = '******' order by 1 desc"; cmd = new OracleCommand(query, conn); htrans.ItemsSource = null; using (OracleDataReader reader = cmd.ExecuteReader()) { List <headerTrans> kodeHtrans = new List <headerTrans>(); while (reader.Read()) { headerTrans temp = new headerTrans(); temp.Kode = reader.GetString(0); temp.Nama = reader.GetString(0); kodeHtrans.Add(temp); } htrans.SelectedValuePath = "Kode"; htrans.DisplayMemberPath = "Nama"; htrans.ItemsSource = kodeHtrans; } conn.Close(); } catch (Exception ex) { conn.Close(); Console.WriteLine(ex.StackTrace); } }
public void loadData() { try { conn.Open(); string query = "select kode_htrans from htrans where fk_pelanggan = '" + kode + "' and status < 2 order by 1 desc"; cmd = new OracleCommand(query, conn); htrans.ItemsSource = null; using (OracleDataReader reader = cmd.ExecuteReader()) { List <headerTrans> kodeHtrans = new List <headerTrans>(); while (reader.Read()) { headerTrans temp = new headerTrans(); temp.Kode = reader.GetString(0); temp.Nama = reader.GetString(0); kodeHtrans.Add(temp); } htrans.SelectedValuePath = "Kode"; htrans.DisplayMemberPath = "Nama"; htrans.ItemsSource = kodeHtrans; } conn.Close(); } catch (Exception ex) { conn.Close(); Console.WriteLine(ex.StackTrace); } }