各位大虾高手快来帮帮我啊,VB+SQL 2005 中treeview使用
时间:2011-11-22
来源:互联网
我用VB的treeview控件来实现结点的添加,并写入数据库中,但是运行了有错误啊,改了很久一直改不出来
Public Sub Add_DepToTree(TreeView1 As TreeView, ByVal TmpKey As String)
Dim dID As String
Dim TmpNode As Node
Dim CurKey As String
Dim strSql As String
Dim rs1 As New ADODB.Recordset
Dim rs2 As New ADODB.Recordset
dID = Right(TmpKey, Len(TmpKey) - 1)
strSql = "select DepId,DepName from Departments where UpperId='" & Trim$(dID) & "'order by DepName"
rs1.Open strSql, Conn, adOpenStatic, adLockReadOnly
Do Until rs1.EOF
If rs2.State = adStateOpen Then rs2.Close
CurKey = "a" & rs1!DepId
strSql = "select count(*) as d_count from Departments where UpperId='" & Trim$(rs1!DepId) & "'"
rs2.Open strSql, Conn, adOpenStatic, adLockReadOnly
If rs2!d_count > 0 Then
Set TmpNode = TreeView1.Nodes.Add(TmpKey, tvwChild, CurKey, rs1!DepName, 2)
Set TmpNode = TreeView1.Nodes.Add(TmpKey, tvwChild, CurKey, rs1!DepName, "imgClosedFolder") ‘总是在这个位置出错,调试提示 key is not unique in collection’ 我看了很久都没有看出哪儿的毛病
TmpNode.ExpandedImage = "imgOpenedFolder"
Call Add_DepToTree(TreeView1, CurKey)
Else
Set TmpNode = TreeView1.Nodes.Add(TmpKey, tvwChild, CurKey, rs1!DepName, "imgDeselectedFile", "imgSelectedFile")
End If
rs2.Close
Set rs2 = Nothing
rs1.MoveNext
Loop
rs1.Close
Set rs1 = Nothing
End Sub
Public Sub Add_DepToTree(TreeView1 As TreeView, ByVal TmpKey As String)
Dim dID As String
Dim TmpNode As Node
Dim CurKey As String
Dim strSql As String
Dim rs1 As New ADODB.Recordset
Dim rs2 As New ADODB.Recordset
dID = Right(TmpKey, Len(TmpKey) - 1)
strSql = "select DepId,DepName from Departments where UpperId='" & Trim$(dID) & "'order by DepName"
rs1.Open strSql, Conn, adOpenStatic, adLockReadOnly
Do Until rs1.EOF
If rs2.State = adStateOpen Then rs2.Close
CurKey = "a" & rs1!DepId
strSql = "select count(*) as d_count from Departments where UpperId='" & Trim$(rs1!DepId) & "'"
rs2.Open strSql, Conn, adOpenStatic, adLockReadOnly
If rs2!d_count > 0 Then
Set TmpNode = TreeView1.Nodes.Add(TmpKey, tvwChild, CurKey, rs1!DepName, 2)
Set TmpNode = TreeView1.Nodes.Add(TmpKey, tvwChild, CurKey, rs1!DepName, "imgClosedFolder") ‘总是在这个位置出错,调试提示 key is not unique in collection’ 我看了很久都没有看出哪儿的毛病
TmpNode.ExpandedImage = "imgOpenedFolder"
Call Add_DepToTree(TreeView1, CurKey)
Else
Set TmpNode = TreeView1.Nodes.Add(TmpKey, tvwChild, CurKey, rs1!DepName, "imgDeselectedFile", "imgSelectedFile")
End If
rs2.Close
Set rs2 = Nothing
rs1.MoveNext
Loop
rs1.Close
Set rs1 = Nothing
End Sub
作者: lizhihua1217 发布时间: 2011-11-22
看着你这一堆代码,就眼花了,难怪没人理你
作者: liutianji0923 发布时间: 2011-11-24
相关阅读 更多
热门阅读
-
office 2019专业增强版最新2021版激活秘钥/序列号/激活码推荐 附激活工具
阅读:74
-
如何安装mysql8.0
阅读:31
-
Word快速设置标题样式步骤详解
阅读:28
-
20+道必知必会的Vue面试题(附答案解析)
阅读:37
-
HTML如何制作表单
阅读:22
-
百词斩可以改天数吗?当然可以,4个步骤轻松修改天数!
阅读:31
-
ET文件格式和XLS格式文件之间如何转化?
阅读:24
-
react和vue的区别及优缺点是什么
阅读:121
-
支付宝人脸识别如何关闭?
阅读:21
-
腾讯微云怎么修改照片或视频备份路径?
阅读:28