About dateTimePicker problem [modified]

[miss YY]

string from,to; from=this.dateTimePicker1.Value.ToShortDateString(); to=this.dateTimePicker2.Value.ToShortDateString(); string str="select * from Furn_Info where Time between ‘"+from+"’ and ‘"+to+""; but i do not want to use "between.....and" i want to use ">=" and "<=", i use data SqL2000,Field "Time" Property is datetime,how should it be? please help me !thanks

modified on Friday, November 27, 2009 8:41 AM

[Rob Philpott]

string str="select * from Furn_Info where Time >= '"+from+"' and Time <= '"+to+"'"; Although you should think about parameterising the 'from' and 'to' rather than building a string with them.

Regards, Rob Philpott.

[Luc Pattyn]

As Rob said, avoid using strings for dates, it only yields problems when you move to a PC with a different datetime formatting. Store real dates and times and datetimes in your database, not strings, and use parameterized SQL, which accepts date/datetime values directly instead of strings. And please use PRE tags to show us your code. :)

Luc Pattyn [Forum Guidelines] [My Articles]

---

I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages

---