protected void LoadAgents(bool bIncludeAll) { string[] sExcludedAgents = { }; ddlAgents.Items.Clear(); DataTable dt = q.Agents(); ddlAgents.DataTextField = "Distributor"; ddlAgents.DataValueField = "MGMAgentNo"; //if (WebConfigurationManager.AppSettings["ExcludeAgentCode"] != null) //{ // sExcludedAgents = WebConfigurationManager.AppSettings["ExcludeAgentCode"].ToString().Split(';'); //} //foreach (string sExclude in sExcludedAgents) //{ // if (sExclude != "") // dt = dt.AsEnumerable().Select(r => r).Where(d => Convert.ToInt32(d["MGMAgentNo"]) != Convert.ToInt32(sExclude)).Select(v => v).CopyToDataTable(); //} DataRow dr = dt.NewRow(); dr["MGMAgentNo"] = -1; dr["Distributor"] = "Please select an agent..."; dt.Rows.InsertAt(dr, 0); if (bIncludeAll) { dr = dt.NewRow(); dr["MGMAgentNo"] = -2; dr["Distributor"] = "All Agents"; dt.Rows.InsertAt(dr, 1); } ddlAgents.DataSource = dt; ddlAgents.DataBind(); //ddlAgents.Items.Clear(); //DataTable dt = q.Agents(); //ddlAgents.DataTextField = "Distributor"; //ddlAgents.DataValueField = "MGMAgentNo"; //DataRow dr = dt.NewRow(); //dr["MGMAgentNo"] = -1; //dr["Distributor"] = "Please select an agent..."; //dt.Rows.InsertAt(dr, 0); //ddlAgents.DataSource = dt; //ddlAgents.DataBind(); }