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; } }