Foxtable(狐表)用户栏目专家坐堂 → SQL 的TreeView问题


  共有4332人关注过本帖树形打印复制链接

主题:SQL 的TreeView问题

帅哥哟,离线,有人找我吗?
hongye
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:一尾狐 帖子:437 积分:2949 威望:0 精华:0 注册:2011/3/15 12:49:00
SQL 的TreeView问题  发帖心情 Post By:2022/4/28 17:12:00 [显示全部帖子]

Dim cmd As New SQLCommand
Dim dt As DataTable
cmd.C
cmd.CommandText = "SELECT DISTINCT * Fro m {面料规格表}"
dt = cmd.ExecuteReader(True)
Dim st As WinForm.ComboBox = Forms("窗口1").Controls("ComboBox1")
Dim su As WinForm.ComboBox = Forms("窗口2").Controls("ComboBox1")
Dim sr As WinForm.ComboBox = Forms("窗口2").Controls("ComboBox2")
Dim tv As WinForm.TreeView
tv = e.Form.Controls("TreeView1")
tv.BuildTree("面料规格表", "规格类别|名称|规格", "[规格类别] =  '" & st.Value & "' ", "规格类别,排序码")

请问这个怎么写

 回到顶部