protected void ddl_Asset_product_type_ad_SelectedIndexChanged(object sender, EventArgs e) { MySqlAsmObjs obj = new MySqlAsmObjs(); obj.Pr_sh_name = ddl_Asset_product_type_ad.SelectedItem.Value; MysqlAsMDBCS ABC = new MysqlAsMDBCS(); DataTable dt = ABC._load_Asset_Short_name(obj); if (dt.Rows.Count > 0) { txt_assetNew_Number.Text = "KPCL/" + dt.Rows[0]["pr_type_sh_Name"].ToString() + "/"; } }
public void _load_products_ddl() { MysqlAsMDBCS ABC = new MysqlAsMDBCS(); DataTable dt = ABC._load_Asset_Products(); ddl_Asset_product_ad.DataSource = dt; ddl_Asset_product_ad.DataTextField = "pr_Name"; ddl_Asset_product_ad.DataValueField = "pr_id"; ddl_Asset_product_ad.DataBind(); ddl_Asset_product_ad.Items.Insert(0, new ListItem("Select One", "0")); if (dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { desktop_hidden_value.Value = dt.Rows[0]["pr_id"].ToString(); Printers_hidden_value.Value = dt.Rows[2]["pr_id"].ToString(); Laptop_hidden_value.Value = dt.Rows[1]["pr_id"].ToString(); } } }