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