public Collection <ListItem> GetAgents() { Collection <ListItem> values = new Collection <ListItem>(); using (DataTable table = Agents.GetAgentDataTable()) { string displayField = ConfigurationHelper.GetDbParameter("SalespersonDisplayField"); table.Columns.Add("salesperson", typeof(string), displayField); foreach (DataRow dr in table.Rows) { values.Add(new ListItem(dr["salesperson"].ToString(), dr["salesperson_id"].ToString())); } return(values); } }