Question

c#里怎么查两个datetimepicker之间的值

string datemin = dateTimePicker1.Value.Date.ToString("yyyy-MM-dd");
string datemax = dateTimePicker2.Value.Date.ToString("yyyy-MM-dd");
string cmd = "SELECT * FROM L2_PO WHERE (CC_REQ_TIME >#" + datemin + "#) AND (CC_REQ_TIME<#"+ datemax +"#)";
弄不出来，求修改

Answer 1

1.用>=或者<=.否则 连续两天之间是查不出结果的
2.用Between AND,用sql参数,直接传递dateTimePicker2.Value作为参数值

追问

求代码 谢谢

追答

1.
CDate
2011/8/3
2011/8/1
2011/8/6
2011/8/4

SELECT * FROM test1 WHERE CDate>#8/3/2011# And CDate=或者=@p1 AND CDATE=@p1 AND CDATE=:p1 AND CDATE<=:p2";

Answer 2

string dateMin = dateTimePicker1.SelectedDate.Value.ToString("yyyy-MM-dd");
string dateMax = dateTimePicker2.SelectedDate.Value.ToString("yyyy-MM-dd");

string cmdTxt = string.Format("SELECT * FROM L2_PO WHERE CC_REQ_TIME > '{0}' AND CC_REQ_TIME < '{1}' ",dateMin,dateMax);

追问

还是没有数据 用得是oracle数据库， 数据库里的数据是2011-8-11，再帮我看看 谢谢