May I know the how to can we write the SQL statement for further cub level (debpth 3 and more)and how to set the Databingds for tha
hi hafees, thanks for the kind words. I also have a part 2 to this article which is dealing with recursions as well, so multi-level : http://weblogs.asp.net/alessandro/archive/2008/03/01/part-2-building-and-binding-hierarchical-data-from-the-database-to-the-asp-net-navigation-controls.aspx
Can I have the vb code for this?
Good one! work great for me
Fantastic - thanks! I used the SQL Server and FOR XML Queries approach but I'm wondering if it could be adapted for use in a DataList? I am developing a shopping cart system and I need to be able to display Products on a page but with a DropDownList next to each Product displaying the Options available. Any ideas would be much appreciated.
Great work man! I think the xslt schema approach would be better if the underlying database is gonna change in the future app structure.