7,763
社区成员
发帖
与我相关
我的任务
分享
'建立数据库连接
Dim conn As New ADODB.Connection
conn.open "…………"
'查询tbAAA表
Dim rs As New ADODB.Recordset
rs.Open "select id,name from tbAAA", conn, adOpenKeyset, adLockReadOnly
'添加到Treeview中
TreeView1.Nodes.Clear '加上这句!!!
While Not rs.EOF
Dim mNode As Node
Set mNode = TreeView1.Nodes.Add
With mNode
.Text = rs.Fields("name")
.Key = "n" & rs.Fields("id")
End With
Set mNode = Nothing
Wend
rs.Close
Set rs = Nothing
'释放数据库连接
conn.Close
Set conn = Nothing
'建立数据库连接
Dim conn As New ADODB.Connection
conn.open "…………"
'查询tbAAA表
Dim rs As New ADODB.Recordset
rs.Open "select id,name from tbAAA", conn, adOpenKeyset, adLockReadOnly
'添加到Treeview中
While Not rs.EOF
Dim mNode As Node
Set mNode = TreeView1.Nodes.Add
With mNode
.Text = rs.Fields("name")
.Key = "n" & rs.Fields("id")
End With
Set mNode = Nothing
Wend
rs.Close
Set rs = Nothing
'释放数据库连接
conn.Close
Set conn = Nothing