I've associated an asp:dropdown with an SPDataSource - What I'm trying to do, is simply display all available categories for a certain custom list - The issue is that the SPDataSource only shows categories for the items that have been added, but on top of it, it shows one category for each item. So if I have 5 items, then I'll get 5 categories with some duplicates.
The Custom list categories are a simple list of choices, such as:
That are made to be selectable via a dropdown when creating the item.
When read via SPDataSource and fed to an ASP:DropDown, I get: - CategoryA - CategoryB - CategoryA - CategoryA
Obviously reading from the items available - I would like to consolidate the list to only show 1 of each category.
Thanks for any help/comment.