关于dateTimePicker控件问题

[hyallenchen117]

放了2个dateTimePicker控件，一个是starttime，一个是endtime

 StartTime = dateTimePicker1.Value;
 EndTime = dateTimePicker2.Value;

ds1 = means.getDataSet("select data,datetime from" + Title + " where elec_classID = " + ID + " and datetime between '" + StartTime + "' and '" + EndTime + "' order by datetime");

ds2 = means.getDataSet("select data, datetime from " + Title + " where  elec_classID = " + ID + " and datetime between '2011-10-13 11:00:00' and  '2011-10-13 12:00:00' order by datetime");

ds1报错 ds2运行正常
那应该就是starttime和endtime的表示方法问题了吧?
求助啊~

[xxcw]

select data,datetime from" + Title + "
少了空格

[allan80]

应该是类型出错，将StartTime 和EndTime 转换成字符串类型。
StartTime.ToString()
EndTime.ToString()

[allan80]

1楼说的没错
ds1 = means.getDataSet("select data,datetime from " + Title + " where elec_classID = " + ID + " and datetime between '" + StartTime.ToString()
+ "' and '" + EndTime.ToString()
+ "' order by datetime");

[hyallenchen117]

[Quote=引用 2 楼 allan80 的回复:]

应该是类型出错，将StartTime 和EndTime 转换成字符串类型。
StartTime.ToString()
EndTime.ToString()
[/Quote]

没用的，就算直接对string starttime = "2011-10-13 11:00:00" 也不行

[hyallenchen117]

[Quote=引用 2 楼 allan80 的回复:]

应该是类型出错，将StartTime 和EndTime 转换成字符串类型。
StartTime.ToString()
EndTime.ToString()
[/Quote]

哥们你眼力劲贼好啊！
我这错误弄了半小时都有了 尼玛！！
THX！！