protected void DD_Kategori_SelectedIndexChanged(object sender, EventArgs e)
{
string com = "select ast_subkateast_Code,ast_subkateast_desc from Ref_ast_sub_kategri_Aset where ast_kategori_Code='" + DD_Kategori.SelectedItem.Value + "'";
SqlDataAdapter adpt = new SqlDataAdapter(com, con);
DataTable dt = new DataTable();
adpt.Fill(dt);
DD_Sub.DataSource = dt;
DD_Sub.DataBind();
DD_Sub.DataTextField = "ast_subkateast_desc";
DD_Sub.DataValueField = "ast_subkateast_Code";
DD_Sub.DataBind();
DD_Sub.Items.Insert(0, new ListItem("--- PILIH ---", ""));
DropDownList1.SelectedValue = "";
}
protected void DD_Kategori_SelectedIndexChanged(object sender, EventArgs e)
{
if (DD_Kategori.SelectedValue == "01")
{
TextBox2.Attributes.Add("Readonly", "Readonly");
TextBox2.Text = "1";
}
else if (DD_Kategori.SelectedValue == "02")
{
TextBox2.Attributes.Add("Readonly", "Readonly");
TextBox2.Text = "1";
}
else if (DD_Kategori.SelectedValue == "03")
{
TextBox2.Attributes.Remove("Readonly");
TextBox2.Text = "";
}
else if (DD_Kategori.SelectedValue == "04")
{
TextBox2.Attributes.Add("Readonly", "Readonly");
TextBox2.Text = "1";
}
else
{
TextBox2.Attributes.Add("Readonly", "Readonly");
TextBox2.Text = "0";
}
string com = "select ast_subkateast_Code,UPPER(ast_subkateast_desc) as ast_subkateast_desc from Ref_ast_sub_kategri_Aset where ast_kategori_code='" + DD_Kategori.SelectedValue + "'";
SqlDataAdapter adpt = new SqlDataAdapter(com, con);
DataTable dt = new DataTable();
adpt.Fill(dt);
DD_Sub.DataSource = dt;
DD_Sub.DataBind();
DD_Sub.DataTextField = "ast_subkateast_desc";
DD_Sub.DataValueField = "ast_subkateast_Code";
DD_Sub.DataBind();
DD_Sub.Items.Insert(0, new ListItem("--- PILIH ---", ""));
dd_qry();
DropDownList1.SelectedValue = "";
}
void ss_subkat()
{
DataSet Ds = new DataSet();
try
{
string com = "select ast_subkateast_Code,upper(ast_subkateast_desc) as ast_subkateast_desc from Ref_ast_sub_kategri_Aset where ast_kategori_Code='" + DropDownList1.SelectedValue + "' and Status='A'";
SqlDataAdapter adpt = new SqlDataAdapter(com, con);
DataTable dt = new DataTable();
adpt.Fill(dt);
DD_Sub.DataSource = dt;
DD_Sub.DataTextField = "ast_subkateast_desc";
DD_Sub.DataValueField = "ast_subkateast_Code";
DD_Sub.DataBind();
DD_Sub.Items.Insert(0, new ListItem("--- PILIH ---", ""));
// pg_load();
}
catch (Exception ex)
{
throw ex;
}
}
protected void DD_Kategori_SelectedIndexChanged(object sender, EventArgs e)
{
DataSet Ds = new DataSet();
try
{
string com = "select wilayah_code,UPPER(wilayah_name) as wilayah_name from Ref_Cawangan where kavasan_name='" + DD_Kategori.SelectedItem.Text + "' group by wilayah_code,wilayah_name";
SqlDataAdapter adpt = new SqlDataAdapter(com, con);
DataTable dt = new DataTable();
adpt.Fill(dt);
DD_Sub.DataSource = dt;
DD_Sub.DataBind();
DD_Sub.DataTextField = "wilayah_name";
DD_Sub.DataValueField = "wilayah_code";
DD_Sub.DataBind();
DD_Sub.Items.Insert(0, new ListItem("--- PILIH ---", ""));
}
catch (Exception ex)
{
throw ex;
}
}
protected void DD_Kategori_SelectedIndexChanged(object sender, EventArgs e)
{
DataSet Ds = new DataSet();
try
{
string com = "select ast_subkateast_Code,ast_subkateast_desc from Ref_ast_sub_kategri_Aset where ast_kategori_Code='" + DD_Kategori.SelectedItem.Value + "'";
SqlDataAdapter adpt = new SqlDataAdapter(com, con);
DataTable dt = new DataTable();
adpt.Fill(dt);
DD_Sub.DataSource = dt;
DD_Sub.DataBind();
DD_Sub.DataTextField = "ast_subkateast_desc";
DD_Sub.DataValueField = "ast_subkateast_Code";
DD_Sub.DataBind();
DD_Sub.Items.Insert(0, new ListItem("--- PILIH ---", ""));
//Grid_bnd();
}
catch (Exception ex)
{
throw ex;
}
}
