查询两个DateTimePicker间的数据 的异常

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