如何绘制MLM asp.net [英] How to Draw MLM asp.net

问题描述

我正在使用

;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

到二进制结构但如何绑定到TreeView

to binary Structure but how to bind to the TreeView

推荐答案

了解ADO。 NET在这里它会帮助你。



选择你喜欢的任何一个：

MSDN：ADO.NET [ ^ ]

MSDN：使用ADO.NET访问数据 [ ^ ]

C＃Station ADO.NET教程 [ ^ ]

为初学者使用ADO.NET [ ^ ]

简单ADO .NET数据库使用C＃读取，插入，更新和删除。 [ ^ ]

Read about ADO.NET here and it will help you.

Pick any one that you like:
MSDN: ADO.NET[^]
MSDN: Accessing Data with ADO.NET[^]
The C# Station ADO.NET Tutorial[^]
Using ADO.NET for beginners[^]
Simple ADO.NET Database Read, Insert, Update and Delete using C#.[^]

这篇关于如何绘制MLM asp.net的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！