这是我用数据库初始化TREEVIEW,你可以改一下,很快就可以实现 Dim strDBName As String
Dim db As Database
Dim tbCount, i, fdCount, j As Integer
Dim litm(1 To 13) As String
Dim nod As Node
Set db = dbengine.opendatabase("d:\vb98\BIBLIO.MDB")
tbCount = db.TableDefs.Count - 1
TreeView1.Nodes.Clear
For i = 0 To tbCount
fdCount = db.TableDefs(i).Fields.Count
If Not Left(db.TableDefs(i).Name, 4) = "MSys" Then
Set nod = TreeView1.Nodes.Add(, , "r" & CStr(i), db.TableDefs(i).Name)
tbCount = db.TableDefs(i).Fields.Count - 1
For j = 0 To tbCount
Set nod = TreeView1.Nodes.Add("r" & CStr(i), tvwChild, , db.TableDefs(i).Fields(j).Name)
Next j
End If
Next i
db.Close
Set db = Nothing
Dim db As Database
Dim tbCount, i, fdCount, j As Integer
Dim litm(1 To 13) As String
Dim nod As Node
Set db = dbengine.opendatabase("d:\vb98\BIBLIO.MDB")
tbCount = db.TableDefs.Count - 1
TreeView1.Nodes.Clear
For i = 0 To tbCount
fdCount = db.TableDefs(i).Fields.Count
If Not Left(db.TableDefs(i).Name, 4) = "MSys" Then
Set nod = TreeView1.Nodes.Add(, , "r" & CStr(i), db.TableDefs(i).Name)
tbCount = db.TableDefs(i).Fields.Count - 1
For j = 0 To tbCount
Set nod = TreeView1.Nodes.Add("r" & CStr(i), tvwChild, , db.TableDefs(i).Fields(j).Name)
Next j
End If
Next i
db.Close
Set db = Nothing
解决方案 »
- 不起眼的问题,奇怪的问题,或许大家都没有注意过的问题,大家帮忙来看下,知道的朋友帮忙回答,不知道的朋友帮忙顶起来!!!
- 讨论:各位高手们用vb操作数据库的方式有哪些?
- 哪位知道如何编成实现将TrueType字体转化成点阵字体
- 如何在窗体上显示超级连接,点击后打开ie显示相应网站?还有电击后打开outlook发送信件。
- 关于DTPicker1控件的问题?望高手能指点一下!!
- 令人头痛的问题,熟悉Webbrowser控件的朋友请进.
- 杭州的朋友进来看下
- API問題ExtractFileFromCab
- 问一个sql语句如何写,简单!
- 如何写一个软件工程的开发文档?我门不是程序远 只是代码狂而已!如何正规?!!!
- 制作一个进度条,平面型的,怎么实现
- vb中没有指针,怎样实现链表?
Set curRecords = gConnection.Execute("SELECT Title,ID FROM tab_Info_class WHERE Parent_Id='-1'")
If curRecords.EOF = False Then
'如果类信息记录集不空,则将现有的类信息标题显示在树型视图中。
'否则,添加一条信息类根节点记录,ID为"00000000000000000001",Title为"信息集合",Parent_Id为"-1"。
'并将此信息类根节点显示在树型视图中。
Set curNode = trvInfoClass.Nodes.Add(, , SJROOTKEY & Trim(CStr(curRecords.Fields("ID"))), Trim(CStr(curRecords.Fields("Title"))), 1, 1)
Call AddChildNodes(curNode)
curRecords.Close
Else
curRecords.Close
Set curRecords = New ADODB.Recordset
Call curRecords.Open("SELECT * FROM tab_Info_class WHERE Parent_Id='-1'", gConnection, adOpenDynamic, adLockPessimistic)
Call curRecords.AddNew
curRecords.Fields("ID") = "00000000000000000001"
curRecords.Fields("Parent_Id") = "-1"
curRecords.Fields("Title") = "信息集合"
Call curRecords.Update
Set curNode = trvInfoClass.Nodes.Add(, , SJROOTKEY & Trim(CStr(curRecords.Fields("ID").Value)), Trim(CStr(curRecords.Fields("Title"))), 1, 1)
Call curRecords.Close
End If
Public Sub AddChildNodes(ByRef rootNode As Node)
'递归显示树视图。
Dim curInfoClassRecords As ADODB.Recordset
Dim curNode As Node
Set curInfoClassRecords = gConnection.Execute("SELECT Title,ID FROM tab_Info_class WHERE Parent_Id='" & Right(rootNode.Key, Len(rootNode.Key) - 4) & "' and " & CURRENTQUERYCONDITION)
If curInfoClassRecords.EOF = True Then ' And curInfoCellRecords.EOF = True Then
curInfoClassRecords.Close
Exit Sub
End If
Do While curInfoClassRecords.EOF = False
Set curNode = trvInfoClass.Nodes.Add(rootNode, tvwChild, SJINFOCLASSKEY & curInfoClassRecords.Fields("ID").Value, curInfoClassRecords.Fields("Title"), 2, 3)
Call curInfoClassRecords.MoveNext
Call AddChildNodes(curNode)
Loop
curInfoClassRecords.Close
End Sub