VB用treeview显示Access数据表中的字段数据有关问题，困惑死小弟我了
VB用treeview显示Access数据表中的字段数据问题，困惑死我了
前面的数据库打开什么的都没问题，添加treeview的最高的那一阶也没问题，到第二阶的时候下面中
Set nodex = TreeView1.Nodes.Add("父" & rec.Fields("大区名称"), tvwChild, "子" & rec.Fields("省份ID"), rec.Fields("省份名称"), "k1", "k2")
句总显示
这个需要用到Access中的'关系‘吗？
rec.Open "省份表", cnn1, adOpenKeyset, adLockOptimistic
For i = 0 To rec.RecordCount - 1
Set nodex = TreeView1.Nodes.Add("父" & rec.Fields("大区名称"), tvwChild, "子" & rec.Fields("省份ID"), rec.Fields("省份名称"), "k1", "k2")
nodex.Sorted = True
rec.MoveNext
Next
------解决方案--------------------
这种错误一般是代码中的字段名称与数据库中的字段不一致引用的
------解决方案--------------------
TreeView1.Nodes.Add ,,"父Key","父标题",1,1
TreeView1.Nodes.Add "父Key",4,"子key1","子标题1",1,1
TreeView1.Nodes.Add "父Key",4,"子key2","子标题2",1,1
TreeView1.Nodes.Add "子key2",4,"子key3","子标题3",1,1
TreeView1.Nodes.Add "子key2",4,"子key4","子标题4",1,1
TreeView1.Nodes.Add "父Key",4,"子key5","子标题5",1,1
前面的数据库打开什么的都没问题，添加treeview的最高的那一阶也没问题，到第二阶的时候下面中
Set nodex = TreeView1.Nodes.Add("父" & rec.Fields("大区名称"), tvwChild, "子" & rec.Fields("省份ID"), rec.Fields("省份名称"), "k1", "k2")
句总显示
这个需要用到Access中的'关系‘吗？
rec.Open "省份表", cnn1, adOpenKeyset, adLockOptimistic
For i = 0 To rec.RecordCount - 1
Set nodex = TreeView1.Nodes.Add("父" & rec.Fields("大区名称"), tvwChild, "子" & rec.Fields("省份ID"), rec.Fields("省份名称"), "k1", "k2")
nodex.Sorted = True
rec.MoveNext
Next
treeview
vb
access
------解决方案--------------------
这种错误一般是代码中的字段名称与数据库中的字段不一致引用的
------解决方案--------------------
TreeView1.Nodes.Add ,,"父Key","父标题",1,1
TreeView1.Nodes.Add "父Key",4,"子key1","子标题1",1,1
TreeView1.Nodes.Add "父Key",4,"子key2","子标题2",1,1
TreeView1.Nodes.Add "子key2",4,"子key3","子标题3",1,1
TreeView1.Nodes.Add "子key2",4,"子key4","子标题4",1,1
TreeView1.Nodes.Add "父Key",4,"子key5","子标题5",1,1