select * from dangqi where getdate()>start and getdate()<eend order by bianhao desc
select * from dangqi where start<=DateTime or end>=DateTime order by bianhao desc
string strNow = DateTime.Now.ToShortDateString(); string strSql = "select * from dangqi where start <= '"+ strNow +"' And eend >= '"+ strNow +"' Order By bianhao desc"
select * from dangqi where start<=#DateTime# and eend>=#DateTime# order by 日期要 用## 扩起来
_tmpCmd.CommandText = "select * from dangqi where start<=@datetime and eend>=@datetime order by bianhao desc" _tmpParam = New SqlParameter("@datetime", SqlDbType.datetime) _tmpParam.Value = datetime myCommand.Parameters.Add(_tmpParam)
你的理解没错,便是DateTime会出错,怎样把datetime放在sql中,
datetime是当前的时羊
string strSql = "select * from dangqi where start <= '"+ strNow +"' And eend >= '"+ strNow +"' Order By bianhao desc"
_tmpParam = New SqlParameter("@datetime", SqlDbType.datetime)
_tmpParam.Value = datetime
myCommand.Parameters.Add(_tmpParam)