SQL hierarchical query replacing XML
===

I'm working on a very complex ASP.NET Web application. The menu is a Treeview which gathers its content out of a XML document. The XML gets generated and gets filled with data out of a SQL database. The data in the SQL database is stored in multiple tables which have dependencies to eachother. So the way to the final menu looks like that.

SQL DB -> XML -> Treeview (Menu)


My question is the following: Is there a way to avoid the step to 'xml' and  read the data hierarchically out of the database into the treeview? Or is there another way to make a treeview directly out of databes data?

I'm using ASP.NET 4.0, SQL SERVER 2008 and the usual .NET Treeview control.

Any help apreciated


