查询两个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 + " ' "