Question

c#如何让写SQl语句查寻dateTimePicker1 dateTimePicker2之间的时间段

string sql = "SELECT dingg.Lm AS 路线名称, dingg.Price AS 单价, dingg.Date AS 订购日起, dingg.Lhao AS 流水号, dingg.Num AS 数量, xl.Chuf AS 出发地点, xl.Tuj AS 途径景点, xl.Chut AS 出团计划, xl.Date AS 出团时间 FROM dingg INNER JOIN xl ON dingg.IDD = xl.ID WHERE (xl.Youx = N'是') and (xl.Date between '"+dateTimePicker1.Value.ToString("yyyy-MM-dd")+"' and '"+dateTimePicker2.Value.ToString("yyyy-MM-dd")+"')";这是我写的，大家看一下，Date字段是datetime 数据类型！

Answer 1

你写的没有问题呀？查询不到数据吗？
注意由于是datetime 与date比较，第二个时间可以向后延一天，否则当天的查不到或者补上时间dateTimePicker2.Value.ToString("yyyy-MM-dd")+"23:59:59"

Answer 2

用大于小于号即可datetime>datetiempicker1 and .............