[求助] 生成目录树速度慢 - 专家坐堂 - Foxtable(狐表) - 新一代数据库软件，完美融合Access、Foxpro、Excel、vb.net之优势，人人都能掌握的快速软件开发工具!

Dim cmd As New SQLCommand

cmd.ConnectionName = "数据源名称"
cmd.CommandText = "SELECT DISTINCT 科目表_一级 as 一级科目, 科目表_二级 as 二级科目,科目表_三级 as 三级科目,科目表_四级 as 四级科目,科目表_五级 as 五级科目 From {流水账} union SELECT DISTINCT 对方科目_一级 as 一级科目, 对方科目_二级 as 二级科目,对方科目_三级 as 三级科目,对方科目四级 as 四级科目,对方科目_五级 as 五级科目 From {流水账}"

Dim dt As DataTable= cmd.ExecuteReader()
Dim trv As WinForm.TreeView = e.Form.Controls("TreeView1")
trv.BuildTree(dt,"一级科目|二级科目|三级科目|四级科目|五级科目")

主题：[求助] 生成目录树速度慢