我想将某一字段的值读到treeview中,我用下面的代码,treeview居然没反应,是哪写错了吗?
Dim conn As New adodb.Connection
Dim rs As New adodb.Recordset
Dim key, text, connstr, rsstr As String
connstr = "Provider=MSDASQL.1;Persist Security Info=False;Data Source=e"
rsstr = "select distinct zzmm from temp where zzmm<>''"
conn.Open connstr
rs.Open rsstr, conn
TreeView1.LineStyle = tvwTreeLines
TreeView1.Style = tvwTreelinesPlusMinusPictureText
If rs.RecordCount > 0 Then
rs.MoveFirst
Do While rs.EOF = False
key = Trim(rs.Fields("zzmm"))
text = Trim(rs.Fields("zzmm"))
Set nodx = TreeView1.Nodes.Add(, , key, text)
Loop
End If
TreeView1.Refresh
Dim conn As New adodb.Connection
Dim rs As New adodb.Recordset
Dim key, text, connstr, rsstr As String
connstr = "Provider=MSDASQL.1;Persist Security Info=False;Data Source=e"
rsstr = "select distinct zzmm from temp where zzmm<>''"
conn.Open connstr
rs.Open rsstr, conn
TreeView1.LineStyle = tvwTreeLines
TreeView1.Style = tvwTreelinesPlusMinusPictureText
If rs.RecordCount > 0 Then
rs.MoveFirst
Do While rs.EOF = False
key = Trim(rs.Fields("zzmm"))
text = Trim(rs.Fields("zzmm"))
Set nodx = TreeView1.Nodes.Add(, , key, text)
Loop
End If
TreeView1.Refresh
解决方案 »
- ado 和adodb一样吗,。。。
- 用ADOData控件作了一个窗体,后来再次打开时发现,要我输入用户密码等,点击否的话还不能直接看到窗体了.....
- VB与DLL间能否传递数组参数,形式应该是怎样的?
- 拷贝到磁盘的文件为什么经过运输和存储后用户打开磁盘是空白的?
- 请问用VB怎么把开始和停止键做到一个按键上,谢谢
- 怎样实现图片的赋值!谢谢!U在线等……!万分火急!谢谢
- 注意:控制光驱舱门开、关的源代码!(▁▂▃▄▅▆▇█ 騩鹬)
- 如何判断winsock返回值?
- =======Fraser01(王晓栋),我开始学习C++了,以后来少了,现在散分==========
- 用VB作线性规划?
- 问高手几个关于动态改变控件大小的问题
- 程序员要当心!揭露杭州艾迪康医学检验中心IT部的卑鄙行径!
应该不是treeview的问题,可能是数据库里面没数据~?
' your code here ... ' This line is very IMPORTANT
rs.MoveNext
Loop
而且还得加个rs.movenext
if rs.recordcount>0处就跳过了不过我就不明白为什么不能立即用Recordset的RecordCount判断记录总数。
You can use RecordCount property
End If