Dim cmd As New SQLCommand
cmd.C
Dim xs as DataTable
cmd.CommandText = "sel ect 创建时间,车牌号,项目,数量,应付款,欠款,备注,创建人,消费方式,订单编号 from {销售明细} where 有效性='有效' and 消费方式<>'刷MR卡' and 数量<>0"
xs = cmd.ExecuteReader()
Dim ex As New Exporter
ex.SourceTableName = "xs" '指定导出表
ex.FilePath = "e:\订单.xls" '指定目标文件
ex.Format = "Excel" '导出格式为Excel
ex.Export() '开始导出
报错,应该怎么写?
[此贴子已经被作者于2018/3/16 20:08:38编辑过]