Can any one give a hint to present data from SQL table in xamDataTree, kind of like the group-by view in datagrid.
For example, the data table looks like this
category product item
Cat1 Prod1 Item1
Cat1 Prod2 Item2
Cat2 Prod1 Item3
Cat2 Prod2 Item4
Cat2 Prod3 Item5
Could you post a screenshot that shows how the XamDataGrid looks like in grouping mode with your data so we can try to implement the same with the XamDataTree.
something like this, plain style, doesn't have to be exact the same, just like "Group by" in XamDataGrid. I know the manual way is to create a IENUMERATE object and put all this into a collection. But, I am thinking, maybe, by using Linq or Entity Framework, there is a easy way to do it.
Cat1
------Prod1
----------------Item1
------Prod2
----------------Item2
Cat2
--------Prod1
----------------Item3
---------Prod2
----------------Item4
---------Prod3
----------------Item5
Check this out:
http://stackoverflow.com/questions/2230202/how-can-i-hierarchically-group-data-using-linq
Let me know if that helps!