Advertisement

12.30.2007 at 03:14AM PST, ID: 23049601
[x]
Attachment Details

populating TreeView from sql CTE hierarchy results

Asked by sagir in .NET Framework 2.0, C# Programming Language, SQL Server 2005

Tags: asp.net 2.0

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.aspx

Thanks,
SagiStart Free Trial
[+][-]01.01.2008 at 08:01AM PST, ID: 20560327

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: .NET Framework 2.0, C# Programming Language, SQL Server 2005
Tags: asp.net 2.0
Sign Up Now!
Solution Provided By: testn
Participating Experts: 1
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628