void sts_pemeri()
{
DataSet Ds = new DataSet();
try
{
string com = "select ast_pemerikksaan_code,ast_pemerikksaan_desc from Ref_ast_sts_pemerikksaan where status='A' order by ast_pemerikksaan_desc asc";
SqlDataAdapter adpt = new SqlDataAdapter(com, con);
DataTable dt = new DataTable();
adpt.Fill(dt);
DD_stspemeri.DataSource = dt;
DD_stspemeri.DataBind();
DD_stspemeri.DataTextField = "ast_pemerikksaan_desc";
DD_stspemeri.DataValueField = "ast_pemerikksaan_code";
DD_stspemeri.DataBind();
DD_stspemeri.Items.Insert(0, new ListItem("--- PILIH ---", ""));
}
catch (Exception ex)
{
throw ex;
}
}
void jawatan()
{
DataSet Ds = new DataSet();
try
{
string com = "select hr_jaw_Code,hr_jaw_desc From Ref_hr_Jawatan where Status='A' order by hr_jaw_desc ASC";
SqlDataAdapter adpt = new SqlDataAdapter(com, con);
DataTable dt = new DataTable();
adpt.Fill(dt);
DD_stspemeri.DataSource = dt;
DD_stspemeri.DataBind();
DD_stspemeri.DataTextField = "hr_jaw_desc";
DD_stspemeri.DataValueField = "hr_jaw_Code";
DD_stspemeri.DataBind();
DD_stspemeri.Items.Insert(0, new ListItem("--- PILIH ---", ""));
}
catch (Exception ex)
{
throw ex;
}
}
