I have a strange ASP.NET app requirement to create a hierarchical view of non-relational data, the datasource being a flat table built from something like a spreadsheet. The table is large so I need to keep it as is and perform the logic in stored procedures and C# code.
This is a logical representation of what I want to see where Business, Contact, and Problem have + signs where you click and expand to get details. There will be many Businesses, Contacts, and Problems. Any direction would be appreciated.
Example hierarchy
BusinessName
SalesRep, SalesRepPhone
Contact
ContactName, Phone, ContactType
Problem
ProblemDate, ProblemDescription, etcetera
After reading about the TreeNodeView, I don't that meets my needs, and I would rather not create a new control foreach Business, if I can avoid it.