Binding TreeViews

[Chris Fulstow]

Hi,

In ASP.NET 2.0, what's the best approach for binding a TreeView control
to data in SQL Server? Is it possible to write a "SELECT ... FOR XML"
type query that you can feed directly into the TreeView? It only seems
possible to bind to a static XML file, or a site map.

Maybe it's just a case of using some ADO.NET to trawl through the
database and add each node dynamically?

Thanks,
Chris

 

[Guest]

There is a free SQL Site Map Data Source control you can get from here
http://msdn.microsoft.com/msdnmag/issues/06/02/WickedCode/

 

[Chris Fulstow]

Great - looks just the job. Thanks