放了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的表示方法问题了吧?
求助啊~
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的表示方法问题了吧?
求助啊~
少了空格
StartTime.ToString()
EndTime.ToString()
ds1 = means.getDataSet("select data,datetime from " + Title + " where elec_classID = " + ID + " and datetime between '" + StartTime.ToString()
+ "' and '" + EndTime.ToString()
+ "' order by datetime");
没用的,就算直接对string starttime = "2011-10-13 11:00:00" 也不行
哥们你眼力劲贼好啊!
我这错误弄了半小时都有了 尼玛!!
THX!!