主题：[求助]根据时间列生成目录树

Dim dt As DataTable

Dim b As New SQLGroupTableBuilder("统计表1","编辑信息表")

b.Groups.AddDef("日期",DateGroupEnum.Year,"年")

b.Groups.AddDef("日期",DateGroupEnum.Month,"月")

b.Groups.AddDef("日期",DateGroupEnum.Day,"日")

dt = b.Build(False) '参数设置为False,生成一个临时表,不在主界面显示

'然后根据统计表生成目录树

Dim trv As WinForm.TreeView = e.Form.Controls("TreeView1")

trv.BuildTree("编辑信息表", "年|月|日")

trv.StopRedraw

For Each nd As WinForm.TreeNode In trv.AllNodes

    Dim Year As Integer = nd.DataRow("年")

    Dim Month As Integer = nd.DataRow("月")

    Dim Day As Integer = nd.DataRow("日")

Next

trv.Nodes.Insert("加载所有行","加载所有行",0)

trv.ResumeRedraw

老师 帮我看一下  这段代码报错

“生成的SQL错误 无法继续统计”  ， “无效列名：年”

Dim b As New SQLGroupTableBuilder("统计表1","编辑信息表")

b.Groups.AddDef("日期",DateGroupEnum.Year,"年")

b.Groups.AddDef("日期",DateGroupEnum.Month,"月")

b.Groups.AddDef("日期",DateGroupEnum.Day,"日")

b.Build