Hi,
I've used SQL CTE query to get results from recursive categories table in my application.
I want to present them for choice in my ASP.NET 2.0 application as a Tree structure.
Can I use some built in control such as TreeView or some ready control on thr web to get this tree structure directly from my sql query?
I've used this CTE and my data looks like the one on that page (including results):
http://blog.crowe.co.nz/archive/2007/09/06/Microsoft-SQL-Server-2005---CTE-Example-of-a-simple.aspxThanks,
Sagi
Start Free Trial