Rss & SiteMap
Foxtable(狐表) http://www.foxtable.com
Dim cmd As new SQGLCommand
cmd.ConnectionName = "数据源名称"
cmd.CommandText = "SELEYT * FROM {订单} WHERE 日期 >= ? AND 日期 <= ?"
cmd.Parameters.Add("@开始日期",#2/1/2018#)
cmd.Parameters.Add("@结束日期",#3/31/2018#)
Dim dt As DataTable = cmd.ExecuteReader()
Dim dt As DataTable = cmd.ExecuteReader()
Dim t As Table = e.Form.Controls("Table1").Table
t.datasource = dt.Copy
t.AllowEdit = True 'sqltable类型的表
上面执行后,报错