Posted 07 Feb 2012
Link to this post
I'm trying to use a RadMenu to select some hierarchical data. I feed the data from a DataTable fine and the hierarchy works when specified, however I would actually like this data to populate at the 3rd tier of the menu. i.e. I'd like the structure as follows:
Category -> Shop -> heirachical data for Shop
-> Fuel -> heirachical data for Fuel
Both shop and fuel data use the ID to ParentID relationship and can be combined into a single DataTable with the differentiating factor being a dummy column with either "shop" or "fuel" (ofc this data could be provided as 2 tables instead). I would like Category to be the root - this is static and does not need to come from the datasource, tho I could add another dummy column "Category" to the query if required.
Is there a way to populate from the 2 data sources at the Shop and Fuel level (shop and fuel are also static and can be specified in advance)?
Any help with this would be greatly appreciated.