日期:2014-05-18  浏览次数:20393 次

急,取两个日期之间的所有数据

//传日期差的参数
int   Days   =Convert.ToInt32(Request.QueryString[ "Days "].Trim());
//利用日期差的参数生成开始时间
string   StartTime=System.DateTime.Now.AddDays(-Days).ToString( "yyyy-MM-dd ");
//取系统当前为结束时间
string   EndTime=System.DateTime   .Now.ToString   ( "yyyy-MM-dd ");
//SQL语句
string   sqlstr   = "select   *   from   Article   where   PublishTime   BETWEEN   StartTime   AND   EndTime   order   by   PublishTime   desc ";

sql语句执行老是出错。

我检查时,发现开始日期和结束日期都是正确的。
以上sql语句如果改成
string   sqlstr   = "select   *   from   Article   where   PublishTime   BETWEEN   '2007-8-9 'AND   '2007-8-11 'order   by   PublishTime   desc ";
可以正确执行。

请各位大侠指教


------解决方案--------------------
string sqlstr = "select * from Article where PublishTime BETWEEN ' " + StartTime + " ' AND

' " + EndTime + " order by PublishTime desc "