private void BindNAVCategory() { DataSet dsNavCategory; DataTable dtNavCategory; dsNavCategory = priceBo.GetNavOverAllCategoryList(); dtNavCategory = dsNavCategory.Tables[0]; if (dtNavCategory.Rows.Count > 0) { ddlCategory.DataSource = dtNavCategory; ddlCategory.DataValueField = dtNavCategory.Columns["Category_Code"].ToString(); ddlCategory.DataTextField = dtNavCategory.Columns["Category_Name"].ToString(); ddlCategory.DataBind(); ddlCategory.Items.Insert(0, new ListItem("All", "All")); } }
private void BindSchemeCategory() { DataSet dsSchemeCategory = new DataSet(); DataTable dtSchemeCategory; dsSchemeCategory = priceBo.GetNavOverAllCategoryList(); //----------------------------------------------Scheme Category Binding------------------------ if (dsSchemeCategory.Tables.Count > 0) { dtSchemeCategory = dsSchemeCategory.Tables[0]; ddlCategory.DataSource = dtSchemeCategory; ddlCategory.DataValueField = dtSchemeCategory.Columns["Category_Code"].ToString(); ddlCategory.DataTextField = dtSchemeCategory.Columns["Category_Name"].ToString(); ddlCategory.DataBind(); } ddlCategory.Items.Insert(0, new ListItem("All", "0")); }