Just out of curiosity is it possible to bind a treeview control to data returned from a CTE?

The windows forms treeview control does not support data binding

Ken is right, treeview does not support databinding. But you can customize/extend it. The following links will be useful

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnwinforms/html/custcntrlsamp3.asp
http://www.codeproject.com/cs/miscctrl/dbTree.asp

ken i meant to ask if a web TreeView Control in .Net 2.0 can be used to display records from a Common Table Expression in SQL-2000 hierarchically.

Following is SQL Code used to build and return the resultset

CREATE TABLE

tblDepartments

( DepartmentID INT,

DepartmentName VARCHAR(1000),

ParentDepartmentID INT

)

INSERT INTO tblDepartments VALUES(1, 'HR', NULL)

INSERT INTO tblDepartments VALUES(2, 'IT', NULL)

INSERT INTO tblDepartments VALUES(3, 'Networking', 2)

INSERT INTO tblDepartments VALUES(4, 'Development', 2)

INSERT INTO tblDepartments VALUES(5, 'ASP.NET Development', 4)

INSERT INTO tblDepartments VALUES(6, 'J2EE Development', 4)

INSERT INTO tblDepartments VALUES(7, 'C#.NET', 5)

INSERT INTO tblDepartments VALUES(8, 'VB.NET', 5)

SELECT * FROM tblDepartments

WITH Hierarchy(DepartmentID, DepartmentName, ParentDepartmentID, HLevel)

AS

(

SELECT DepartmentID, DepartmentName, ParentDepartmentID, 0 as HLevel FROM tblDepartments

UNION ALL

SELECT SubDepartment.DepartmentID

, SubDepartment.DepartmentName,

SubDepartment.ParentDepartmentID,

HLevel + 1

FROM tblDepartments SubDepartment

INNER JOIN Hierarchy ParentDepartment

ON SubDepartment.ParentDepartmentID = ParentDepartment.DepartmentID )

SELECT DepartmentID,

DepartmentName = Replicate('.', HLevel) + DepartmentName,

ParentDepartmentID,

HLevel

FROM Hierarchy

Any help on the proper usage of CTE would be great