<div>
Is it a recursive table? In that case I prefer to use a &quot;FOR XML&quot; query to get the data in XML and an XSL file with a recursive template to build the tree.
</div>


Is it a recursive table? In that case I prefer to use a "FOR XML" query to get the data in XML and an XSL file with a recursive template to build the tree.

<div>
This is how you can populate TreeView using XML:<br />
<br />
<a href="http://support.microsoft.com/kb/317597" rel="ugc nofollow">http://support.microsoft.com/kb/317597</a>
</div>


This is how you can populate TreeView using XML:

http://support.microsoft.com/kb/317597 [http://support.microsoft.com/kb/317597]

<div>
So, for the TreeView control you need the XML to already be hierarchical structured. You don't get that easily from a recursive table in a database. <br />
<br />
But the matter here is if the table is recursive. From the description in the question it does not look that way, because of the &quot;ten columns&quot; remark. Please, show the table design.
</div>


So, for the TreeView control you need the XML to already be hierarchical structured. You don't get that easily from a recursive table in a database.

But the matter here is if the table is recursive. From the description in the question it does not look that way, because of the "ten columns" remark. Please, show the table design.

multiColumnTree.png

test-tree-validation-small.png

<div>
<div class="content wysiwyg-content">
I have a table that has ten columns that represent a hierarchal structure that I want to visually represent in a treeview. &nbsp;Looking for the best way to load the structure. &nbsp;The columns would be like<br />
<br />
Lev1<br />
Lev2<br />
Lev3<br />
<br />
Thanks,
</div>
</div>


I have a table that has ten columns that represent a hierarchal structure that I want to visually represent in a treeview.  Looking for the best way to load the structure.  The columns would be like

Lev1
Lev2
Lev3

Thanks,

Multi-Level Treeview

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications