AspNetAtoms.com daily updates on ASP.NET Tutorials, Articles, Authors and more. Subscribe to our newsletter and receive updates on ASP.NET resources on the Internet.

Categories

Recent Posts

Building TreeView Resultset with SQL Server 2005 : Ameet Phadnis

Friday, July 04 2008

This article is an upgrade of my previous article on Building Tree View Resultset. It explains how we can create the Tree View Resultset with SQL 2005 with just one SQL Statement. In a corporate environment we usually face coding tasks to display results in Treeview. The tasks may include displaying corporate structure or in programs displaying the menu structure. Around 5 to 6 years ago when I was tasked with a similar kind of assignment, my manager wanted me to get the results through the SQL Stored Procedure and then the web front end would do the rest. I came up with a way to create the tree hierarchy in SQL Server 2000. It was very complex and hard to understand. We had no idea how much SQL Server 2005 would simplify our lives. I have explained the procedure in my previous article. You can view the article by clicking here. Before I give you the SQL Script, I would like to explain some of the new features introduced in SQL Server 2005....



Read More:
Building TreeView Resultset with SQL Server 2005 : Ameet Phadnis
Also See:
Updating and Deleting Existing Binary Data : Scott Mitchell
New ASP.NET Dynamic Data Support : Scott Guthrie
Working with Computed Columns : Scott Mitchell
How to implement remote debugging in Visual Studio 2005 : Akshay N. S.

Post your comment

Comment