I have a category table that effectively has CategoryID, CategoryName and ParentID. In the table, the 3 top-level categories have a parent of 0 and all remaining categories are children of the top 3.
There is also a presenter table and a presentercategory table that bridges presenters with categories. It's fields are PresentercatID(PK), CategoryID and PresenterID.
I am now required to display these categories in an ASP.NET (vb) page such that the categories are displayed alphabetically and that the parent/child relationships are exposed through progressive UL-LI HTML tags like this:
What would be the best approach to doing this?
Thanks in advance!