Access 时间参数化查询问题
数据库中正常查询:
select * from SendMessage where CreateTime between #2018/9/1# and #2018/9/14# order by CreateTime desc
代码:
sql : select * from SendMessage where CreateTime between @TimeStart and @TimeEnd order by CreateTime desc
parameters.Add(new OleDbParameter("TimeStart", "#" + StartTime + "#"));
parameters.Add(new OleDbParameter("TimeEnd", "#" + EndTime + "#"));
查询不出来呀 咋整。。。。。。。。。。。。。