Question

vb.net从数据库读取信息填充treeview做成层次目录怎么做

SQL2005下的数据库,可以无限添加新类别的.

Answer 1

给你一段我曾经写的代码，主要是生成TreeView的节点！有什么不懂的地方你就提！

Public Sub InitializeTreeView(ByVal strvXL As TreeView, ByVal vrsRecordTwo As DataSet)
Dim treBaseNodeOne As TreeNode
Dim treBaseNodeTwo As TreeNode
Dim strDWDM As String

m_rsRecordTwo = g_clsSybase.SelectSC_PD_SBCSB1()

'查找供电局信息
g_clsSybase.SelectRS_ZZJG_ZZJGDMB(m_rsRecordOne)

'添加根节点
Do While m_rsRecordOne.Read
strDWDM = m_rsRecordOne.GetString(0) '获取单位代码
treBaseNodeOne = New TreeNode
treBaseNodeOne.Text = m_rsRecordOne.GetString(1).Trim() '获取单位名称
treBaseNodeOne.Name = m_rsRecordOne.GetString(1)
treBaseNodeOne.Tag = ""

strvXL.Nodes.Add(treBaseNodeOne)

'添加树结构第二层
Dim drsTwo() As DataRow
drsTwo = m_rsRecordTwo.Tables(0).Select("SSDW='" & strDWDM & "' and SC__XLBM is null")

For Each dr As DataRow In drsTwo
treBaseNodeTwo = New TreeNode
treBaseNodeTwo.Text = dr.Item("XLMC").ToString.Trim
treBaseNodeTwo.Name = dr.Item("XLMC")
treBaseNodeTwo.Tag = dr.Item("XLBM")

treBaseNodeOne.Nodes.Add(treBaseNodeTwo)
Next
Loop
m_rsRecordOne.Close()
End Sub

Answer 2

protected void Page_Load(object sender, EventArgs e)
{
BindDataBase();
TreeView1.ShowLines = true;//显示连接父节点与子节点间的线条
TreeView1.ExpandDepth = 1;//控件显示时所展开的层数
}
public void BindDataBase()
{
//实例化SqlConnection对象
SqlConnection sqlCon = new SqlConnection();
//实例化SqlConnection对象连接数据库的字符串
sqlCon.ConnectionString = \"server=a\\\\mr;uid=sa;pwd=;database=db_Student\";
//实例化SqlDataAdapter对象
SqlDataAdapter da = new SqlDataAdapter(\"select * from tb_StuInfo\", sqlCon);
//实例化数据集DataSet
DataSet ds = new DataSet();
da.Fill(ds, \"tb_StuInfo\");
//下面的方法动态添加了TreeView的根节点和子节点
//设置TreeView的根节点
TreeNode tree1 = new TreeNode(\"学生信息\");
this.TreeView1.Nodes.Add(tree1);
for (int i = 0; i < ds.Tables[\"tb_StuInfo\"].Rows.Count; i++)
{
TreeNode tree2 = new TreeNode(ds.Tables[\"tb_StuInfo\"].Rows[i][1].ToString(), ds.Tables[\"tb_StuInfo\"].Rows[i][1].ToString());
tree1.ChildNodes.Add(tree2);
//显示TreeView根节点下的子节点
for (int j = 0; j < ds.Tables[\"tb_StuInfo\"].Columns.Count; j++)
{
TreeNode tree3 = new TreeNode(ds.Tables[\"tb_StuInfo\"].Rows[i][j].ToString(), ds.Tables[\"tb_StuInfo\"].Rows[i][j].ToString());
tree2.ChildNodes.Add(tree3);
}
}

Answer 3

给你一段我曾经写的代码，主要是生成TreeView的节点，有什么不懂的地方你就提，

Public Sub InitializeTreeView(ByVal strvXL As TreeView， ByVal vrsRecordTwo As DataSet)
Dim treBaseNodeOne As TreeNode
Dim treBaseNodeTwo As TreeNode
Dim strDWDM As String

m_rsRecordTwo = g_clsSybase.SelectSC_PD_SBCSB1()

'查找供电局信息
g_clsSybase.SelectRS_ZZJG_ZZJGDMB(m_rsRecordOne)

'添加根节点
Do While m_rsRecordOne.Read
strDWDM = m_rsRecordOne.GetString(0) '获取单位代码
treBaseNodeOne = New TreeNode
treBaseNodeOne.Text = m_rsRecordOne.GetString(1).Trim() '获取单位名称
treBaseNodeOne.Name = m_rsRecordOne.GetString(1)
treBaseNodeOne.Tag = ""

strvXL.Nodes.Add(treBaseNodeOne)

'添加树结构第二层
Dim drsTwo() As DataRow
drsTwo = m_rsRecordTwo.Tables(0).Select("SSDW='" & strDWDM & "' and SC__XLBM is null")

For Each dr As DataRow In drsTwo
treBaseNodeTwo = New TreeNode
treBaseNodeTwo.Text = dr.Item("XLMC").ToString.Trim
treBaseNodeTwo.Name = dr.Item("XLMC")
treBaseNodeTwo.Tag = dr.Item("XLBM")

treBaseNodeOne.Nodes.Add(treBaseNodeTwo)
Next
Loop。

Answer 4

一般的做法使用递归循环添加节点，首先添加根节点然后逐层递归添加子节点我开发asp.net的树形目录就是那么开发的。