public void ambil_nik() { DataSet data = new karyawan_dao().tampil_karyawan(); cb_nik.DataSource = data.Tables[0]; cb_nik.DisplayMember = "Nik"; }
private void crv_karyawan_Load(object sender, EventArgs e) { DataSet data = new karyawan_dao().tampil_karyawan(); DataTable dt = new DataTable(); dt = data.Tables[0]; cr_karyawan obj_rpt = new cr_karyawan(); obj_rpt.SetDataSource(dt); crv_karyawan.ReportSource = obj_rpt; crv_karyawan.Refresh(); }
private void frm_kasir_Load(object sender, EventArgs e) { lbl_kd_kasir.Text = kd_nik; binding(); txt_kd_berikut.Hide(); karyawan k = new karyawan(); k.nik = lbl_kd_kasir.Text; DataSet ds = new karyawan_dao().carinama_kasir(k); lbl_nama_kasir.Text = ds.Tables[0].Rows[0][0].ToString(); lbl_kd_kasir.Hide(); }
public void binding() { DataSet data = new karyawan_dao().tampil_karyawan(); dgv_karyawan.DataSource = data; dgv_karyawan.DataMember = "t_karyawan"; DataGridViewColumn kolom1 = dgv_karyawan.Columns[0]; kolom1.Width = 120; kolom1.HeaderText = "NIK"; DataGridViewColumn kolom2 = dgv_karyawan.Columns[1]; kolom2.Width = 170; kolom2.HeaderText = "Nama"; DataGridViewColumn kolom3 = dgv_karyawan.Columns[2]; kolom3.Width = 190; kolom3.HeaderText = "Jenis Kelamin "; DataGridViewColumn kolom4 = dgv_karyawan.Columns[3]; kolom4.Width = 160; kolom4.HeaderText = "Tempat Lahir "; DataGridViewColumn kolom5 = dgv_karyawan.Columns[4]; kolom5.Width = 170; kolom5.HeaderText = "Tanggal Lahir"; DataGridViewColumn kolom6 = dgv_karyawan.Columns[5]; kolom6.Width = 150; kolom6.HeaderText = "Agama"; DataGridViewColumn kolom7 = dgv_karyawan.Columns[6]; kolom7.Width = 130; kolom7.HeaderText = "Pendidikan"; DataGridViewColumn kolom8 = dgv_karyawan.Columns[7]; kolom8.Width = 130; kolom8.HeaderText = "Jabatan"; }
private void btn_cari_Click(object sender, EventArgs e) { karyawan k = new karyawan(); if (cmb_cari.Text == "NIK") { try { k.nik = txt_cari.Text; DataSet ds = new karyawan_dao().carikode(k); dgv_karyawan.DataSource = ds; dgv_karyawan.DataMember = "db_indomart"; } catch { MessageBox.Show("Not Found"); } } else if (cmb_cari.Text == "Nama") { k.nama = txt_cari.Text; DataSet ds = new karyawan_dao().carinama(k); dgv_karyawan.DataSource = ds; dgv_karyawan.DataMember = "db_indomart"; } else if (cmb_cari.Text == "Jabatan") { k.jabatan = txt_cari.Text; DataSet ds = new karyawan_dao().carijabatan(k); dgv_karyawan.DataSource = ds; dgv_karyawan.DataMember = "db_indomart"; } }