Databound TreeView

[Loopsludge]

Using ASP.NET 2005/C# flavor, I need to dynamically populate a TreeView
control from the results of a SQL Server 2005 query. Clicking on the
end leaf of the tree will need to yield some details about that leaf
(Assuming I need to hit the database again) in a data view.

In terms of populating the TreeView, will I need to query the database
as XML in order to simplify the generation of the hierarchical results
in the tree? Or will it do this automajically as part of "declaritive
binding model" employed by .NET 2.0? Or will I need to iterate thru
the query results and add nodes, leaves, etc. manually?

Any suggestions are greatly appreciated.
Does anyone know of a good sample I can check out?
I'm also open to any 3rd Party tools for this task if it will make my
life easier.

Thanks in advance.
Loopsludge

 

[Guest]

Hello Loppsludge - check out the recent msdn article by Jeff Prosise:
http://msdn.microsoft.com/msdnmag/issues/06/02/WickedCode/

 

[Teemu Keiski]

Hi,

sample of manual way:

http://aspalliance.com/732

You can also do it declaratively if you develop a hierarchical data source
(control) for your data.
http://msdn2.microsoft.com/en-US/library/system.web.ui.hierarchicaldatasourcecontrol(VS.80).aspx