void PopulateCmbKodeBarang() { MySqlDataAdapter mda = Koneksi.ExecuteRead("Select kode_barang From tb_barang"); DataTable dt = new DataTable(); mda.Fill(dt); foreach (DataRow dr in dt.Rows) { cmbKodeBarang.Items.Add(dr[0]); } }
void PopulateComboBox() { MySqlDataAdapter tahun = Koneksi.ExecuteRead("SELECT EXTRACT(YEAR FROM `tb_gudang`.`tanggal`) AS Tahun FROM `tb_gudang` UNION SELECT EXTRACT(YEAR FROM tb_kasir.`tanggal`) FROM tb_kasir"); DataTable dt = new DataTable(); tahun.Fill(dt); foreach (DataRow dr in dt.Rows) { cmbTahun.Items.Add(dr["Tahun"].ToString()); } }
void PopulateCmbSupplier() { MySqlDataAdapter mda = Koneksi.ExecuteRead("Select DISTINCT suplier From tb_gudang"); DataTable dt = new DataTable(); mda.Fill(dt); foreach (DataRow dr in dt.Rows) { cmbSupplier.Items.Add(dr[0]); } }