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() + "/"; } }