Greetings,
I am obtaining a dataset from mysql database using UNION property of sql combining three tables with 3 columns, text field, datafield id and parent id.
One table consists of regions (germany south germany west and germany north)
second table consists of sub regions.
I can show these two tables on the tree list without problem.
However the third table consists of engineers and their parent id's are either regions or sub regions. All the engineers have unique ID's and none of the engineer ID are same with region or sub-region ID's.
I tried to bind only engineer list to treeview (by setting parent ID's to null). This also worked. but when I get proper parent ID's and bind the engineer list with sub-regions & regions, I receive the error "These columns don't currently have unique values." although all the datafield ID's are unique. I have searched the forums and checked examples yet could not find a solution.
Any help will be highly appreciated
Kind regards
I am obtaining a dataset from mysql database using UNION property of sql combining three tables with 3 columns, text field, datafield id and parent id.
One table consists of regions (germany south germany west and germany north)
second table consists of sub regions.
I can show these two tables on the tree list without problem.
However the third table consists of engineers and their parent id's are either regions or sub regions. All the engineers have unique ID's and none of the engineer ID are same with region or sub-region ID's.
I tried to bind only engineer list to treeview (by setting parent ID's to null). This also worked. but when I get proper parent ID's and bind the engineer list with sub-regions & regions, I receive the error "These columns don't currently have unique values." although all the datafield ID's are unique. I have searched the forums and checked examples yet could not find a solution.
Any help will be highly appreciated
Kind regards
1 Answer, 1 is accepted
0
Hello,
As far as I understand you want to show all three tables records in same RadTreeView control. If this is so please explain how exactly you want to show that data in one RadTreeView. The regions will be the root nodes, all sub-regions will be added as child nodes for each associated region node. In this case at which level in the RadTreeView hierarchy do you want to add the engineers and how you want to link them to the regions? A sample structure with couple of regions, sub regions and engineers data will be very helpful.
Regards,
Boyan Dimitrov
Telerik
As far as I understand you want to show all three tables records in same RadTreeView control. If this is so please explain how exactly you want to show that data in one RadTreeView. The regions will be the root nodes, all sub-regions will be added as child nodes for each associated region node. In this case at which level in the RadTreeView hierarchy do you want to add the engineers and how you want to link them to the regions? A sample structure with couple of regions, sub regions and engineers data will be very helpful.
Regards,
Boyan Dimitrov
Telerik
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to the blog feed now.