protected void DD_Bahagi_SelectedIndexChanged(object sender, EventArgs e)
{
if (DD_Bahagi.SelectedItem.Value == "--- PILIH ---")
{
subj.Rows.Clear();
DD_Subje.Items.Clear();
DD_Subje.Items.Insert(0, new ListItem("--- PILIH ---", ""));
}
//-Pusat---------------------------------------------------------------------------------
string cmd6 = "select csb_subject_cd,csb_subject_desc From hr_cmn_subject as SBJ left join hr_cmn_appr_section as SEC on SEC.cse_section_cd=SBJ.csb_section_cd where csb_section_cd='" + DD_Bahagi.SelectedItem.Value.Trim() + "' order by csb_subject_cd";
subj.Rows.Clear();
DD_Subje.Items.Clear();
con.Open();
SqlDataAdapter adapterP = new SqlDataAdapter(cmd6, con);
adapterP.Fill(subj);
DD_Subje.DataSource = subj;
DD_Subje.DataTextField = "csb_subject_desc";
DD_Subje.DataValueField = "csb_subject_cd";
DD_Subje.DataBind();
//ddPusat.Items.RemoveAt(0); //remove 'Semua Wilayah'
con.Close();
DD_Subje.Items.Insert(0, new ListItem("--- PILIH ---", ""));
grid();
}
void subject()
{
DataSet Ds = new DataSet();
try
{
SqlConnection con = new SqlConnection(conString);
string com = "select csb_subject_cd,csb_subject_desc From hr_cmn_subject as SBJ left join hr_cmn_appr_section as SEC on SEC.cse_section_cd=SBJ.csb_section_cd where csb_subject_cd='" + DD_Bahagi.SelectedValue.Trim() + "' order by csb_subject_cd";
SqlDataAdapter adpt = new SqlDataAdapter(com, con);
DataTable dt = new DataTable();
adpt.Fill(dt);
DD_Subje.DataSource = dt;
DD_Subje.DataBind();
DD_Subje.DataTextField = "kavasan_name";
DD_Subje.DataValueField = "kawasan_code";
DD_Subje.DataBind();
DD_Bahagi.Items.Insert(0, new ListItem("--- PILIH ---", ""));
}
catch (Exception ex)
{
throw ex;
}
}
