查询两个DateTimePicker间的数据 的错误
mysql = "select * from 订单 where 订单日期 between ' " + Me.DateTimePicker1.Value.Date + " ' and ' " + Me.DateTimePicker2.Value.Date + " ' "
查询日期间的数据集
订单日期 为时间型数据
我查询时老出现错误:(帮我分析下错误的可能) 怎么解决
标准表达式中数据类型不匹配
[解决办法]
mysql = "select * from 订单 where 订单日期 between ' " + Me.DateTimePicker1.Value.Date.tostring + " ' and ' " + Me.DateTimePicker2.Value.Date.tostring + " ' "
