加好友 发短信
等级:狐神
帖子:6708
积分:34304
威望:0
精华:11
注册:2012/8/18 23:10:00
|
Post By:2012/9/22 9:31:00 [显示全部帖子]
增加年列和月列,才能达到你要的效果 参考: http://www.foxtable.com/help/topics/1285.htm 或者,自己这样编写代码,参考 Dim
cmd
As
New
SQLCommand Dim
dt
As
DataTable cmd.CommandText = "SELECT
DISTINCT Year(日期) As 年, Month(日期) As 月, 产品 From {订单}" dt = cmd.ExecuteReader() Dim
trv
As
WinForm.TreeView = e.Form.Controls("TreeView1") trv.BuildTree(dt, "年|月|产品")
|
|