Click here to Skip to main content
15,884,099 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I am using
SQL
;WITH FamilyTree
AS
(
    SELECT *, CAST(NULL AS VARCHAR(500)) AS ParentName, 0 AS Generation
    FROM dbo.TBL_USER_MASTER
    WHERE MCID =@id 
    
    UNION ALL
    
    SELECT Fam.*,FamilyTree.UNAME AS ParentName, Generation + 1
    FROM TBL_USER_MASTER AS Fam
    INNER JOIN FamilyTree
    ON Fam.MCID = FamilyTree.UID
)
SELECT * FROM FamilyTree


to binary Structure but how to bind to the TreeView
Posted
Updated 17-Jul-18 1:11am
Comments
bbirajdar 24-Jan-13 9:48am    
Heard of ADO.NET ?

1 solution

 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900