//Get Data From databases, post to Data Grid View
public void binding()
{
DataSet data = new PegawaiDao().ShowEmployee();
dgv_pegawai.DataSource = data;
dgv_pegawai.DataMember = "users";
DataGridViewColumn column0 = dgv_pegawai.Columns[0];
column0.Width = 35;
column0.HeaderText = "No.";
DataGridViewColumn column1 = dgv_pegawai.Columns[1];
column1.Width = 100;
column1.HeaderText = "Employee ID";
DataGridViewColumn column2 = dgv_pegawai.Columns[2];
column2.Width = 175;
column2.HeaderText = "User Name";
DataGridViewColumn column3 = dgv_pegawai.Columns[3];
column3.Width = 70;
column3.HeaderText = "Status";
DataGridViewColumn column4 = dgv_pegawai.Columns[4];
column4.Width = 150;
column4.HeaderText = "Passwords";
}
private void btn_cari_Click(object sender, EventArgs e)
{
if (txt_cari.Text == "")
{
MessageBox.Show("Please Input Keywords ! ", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
Pegawai p = new Pegawai();
if (cmb_cari.Text == "User Name")
{
try{
p.nama_pegawai = txt_cari.Text;
DataSet ds = new PegawaiDao().FindByName(p);
dgv_pegawai.DataSource = ds;
dgv_pegawai.DataMember = "users";
eventclickgrid();
}
catch (DataException) {
MessageBox.Show("User Name Not Found !", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else if (cmb_cari.Text == "Employee ID")
{
try {
p.id_pegawai = txt_cari.Text;
DataSet ds = new PegawaiDao().FindById(p);
dgv_pegawai.DataSource = ds;
dgv_pegawai.DataMember = "users";
eventclickgrid();
}
catch (DataException) {
MessageBox.Show("Employee ID Not Found !", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
private void Frm_rpt_pegawai_Load(object sender, EventArgs e)
{
DataSet data = new PegawaiDao().ShowEmployee();
DataTable dt = new DataTable();
dt = data.Tables[0];
Cr_pegawai obj_rpt = new Cr_pegawai();
obj_rpt.SetDataSource(dt);
Crv_pegawai.ReportSource = obj_rpt;
Crv_pegawai.Refresh();
}
