Question

C# 通过两个dateTimePicker控件查询ACCESS里的内容，怎么总是不行啊

string strSelect = "select * from jcmx where rq >= " + dateTimePicker1.Value.Date.ToString() + " and rq<=" + dateTimePicker2.Value.Date.ToString() + " order by 编号 desc";

Answer 1

改成string strSelect = "select * from jcmx where rq >= '" + dateTimePicker1.Value.Date.ToString() + "' and rq<='" + dateTimePicker2.Value.Date.ToString() + "' order by 编号 desc";

或者string strSelect =string.format("select * from jcmx where rq >='{0}' and rq<='{1}' order by 编号 desc",dateTimePicker1.Value.Date.ToString() ,dateTimePicker2.Value.Date.ToString());

Answer 2

string strSelect = "select * from jcmx where rq >= #" + dateTimePicker1.Value.Date.ToString() + "# and rq<=#" + dateTimePicker2.Value.Date.ToString() + "# order by 编号 desc";
access里面的时间，要用 #2000-01-01#的格式来表示。

Answer 3

rq是时间字段？
select * from jcmx where convert(datetime,rq) between datatime dateTimePicker1.Value.Date and dateTimePicker2.Value.Date order by 编号 desc