Question

C# datetimepicker查询数据库

用2个datetimepicker实现查询时间段数据,如下
string a,b;
a=this.dateTimePicker1.Value.ToShortDateString();
b=this.dateTimePicker2.Value.ToShortDateString();
string str="select * from Furn_Info where Time between ‘"+from+"’
and ‘"+to+"’";
写出来不行,我现在不知道where 后面该怎么写了?我用的是SQL2000,Time的属性是Datetime的,请高手指教!

Answer 1

str="select * from Furn_Info where Time between '"
+ this.dateTimePicker1.Value.ToString("yyyy-MM-dd hh:mm:ss")
+ "' and '" +
this.dateTimePicker2.Value.ToString("yyyy-MM-dd hh:mm:ss")
+ "'"