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]);
}
}