老师,'Dim b As New SQLGroupTableBuilder("统计表1","订单")
'b.Groups.AddDef("日期",DateGroupEnum.Year,"年")
'b.Groups.AddDef("日期",DateGroupEnum.Month,"月")
'b.Groups.AddDef("客户")
'b.Groups.AddDef("产品")
'b.Totals.AddDef("_Identify",AggregateEnum.Count,"订单数")
'dt = b.Build(False) '参数设置为False,生成一个临时表,不在主界面显示
上面改成select 写法
这部分
'b.Totals.AddDef("_Identify",AggregateEnum.Count,"订单数")
加入临时列怎么做
cmd99.CommandText = "SELECT DISTINCT Year(日期) As 年, Month(日期) As 月,客户,产品 Fr om {订单} "
tb.Table.DataSource=cmd99.ExecuteReader