Foxtable(狐表)用户栏目专家坐堂 → [求助]目录树节点显示样式


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

主题:[求助]目录树节点显示样式

美女呀,离线,留言给我吧!
shaof
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:婴狐 帖子:67 积分:491 威望:0 精华:0 注册:2008/9/11 15:30:00
  发帖心情 Post By:2012/3/26 0:48:00 [显示全部帖子]

好像没看明白。

 

Dim cmb2 As WinForm.CheckedListBox = e.Form.Controls("CheckedListBox1")
Dim trv As WinForm.TreeView = e.Form.Controls("TreeView1")
Dim cmd As New SQLCommand
Dim dt As DataTable
cmd.ConnectionName  = "数据库"
cmd.CommandText = "SELECT 订单号,客户,单价,数量 From {订单} where [客户] = '" & e.Form.Controls("客户").value & "'"
dt = cmd.ExecuteReader()
trv.CreateTree(dt, "订单号")
Dim Lis As List(Of String()) = dt.GetUniqueValues("", "订单号","单价","数量")
Dim str As String
For Each Li As String() In Lis
    str & = Li(0) & " " & Li(1) & " " & Li(2) & "|"
Next
cmb2.ComboList= str


 回到顶部