예제 #1
0
        public void ambil_nik()
        {
            DataSet data = new karyawan_dao().tampil_karyawan();

            cb_nik.DataSource    = data.Tables[0];
            cb_nik.DisplayMember = "Nik";
        }
예제 #2
0
        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();
        }
예제 #3
0
        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();
        }
예제 #4
0
        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";
        }
예제 #5
0
        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";
            }
        }