Set cn1 = New adodb.Connection
cn1.Open "Driver={SQL Server};Server=" & SQL_SRV & ";Uid=" & SA & ";Pwd=" & PA & ";Database=" & SJK & ""
Set nodeX = trv1.Nodes.Add(, , "root", "aaaa123", 2, 2)
' 读取节点
Set rs1 = New adodb.Recordset
rs1.Open "select * from tree ", cn1
While Not rs1.EOF
'确定添加到树中的节点
If rs1!cs = 2 Then
Set nodeX = trv1.Nodes.Add(Right(rs1!p, Len(rs1!id)), tvwChild, rs1!id, rs1!Name, 1, 3)
ElseIf rs1!cs = 3 Then
Set nodeX = trv1.Nodes.Add(Right(rs1!p, Len(rs1!id)), tvwChild, rs1!id, rs1!Name, 4, 4)
End If
rs1.MoveNext
Wend