datatimepicker 控件日期格式

Question

两个datatimepicker控件datatimepicker1和datatimepicker2 选择日期2008-05-04和 2008-010-8 
做查询 （表table1的time字段为日期类型）根据time字段做查询  选择怎样写一条查询语句  要根据datatimepicker控件的值做查询？？

Answer 1

什么意思？是这样吗？
select * from table1 where time>cast('" + dateTimePicker1.Value.ToString() + "' as datetime)  and time <cast('" + dateTimePicker2.Value.ToString() + "' as datetime)

Answer 2

不就是查出来了。
between 第一个选择值 and 第二个选择值
如果怕查不出当天就
'" + dateTimePicker2.Value.ToString() + "23:59:59' 

Answer 3

SELECT * FROM DATABASE WHERE TIME1=THIS.datatimepicker.VALUE.TOSTRING() AND TIME2=THIS.datatimepicker.VALUE.TOSTRING();

Answer 4

Stringbuilder sb = new Stringbuilder("");sb.ApplendLine("Select * From Table");
sb.ApplendLine("Where Time>='" +datatimepicker1.value.toShortDateString()+ " 0:00:00'");
sb.ApplendLine(" AND Time<='" +datatimepicker2.value.toShortDateString()+ " 23:59:59'");