您的位置:程序门 -> .net技术 -> web services



简单的c#sql查询语句错误(急)


[收藏此页] [打印本页]选择字色:背景色:字体:[][][]


简单的c#sql查询语句错误(急)
发表于:2007-12-20 12:12:09 楼主
string   strsql   =   "select   *   from   sale_view   where   [date]   > ='"   +   this.datetimepicker1.value.toshortdatestring()+   "   00:00:00   '"and   [date] <   ='"   +   datetimepicker1.value.toshortdatestring()   +   "23:59:59'";
请大家帮我改正一下
谢谢了
发表于:2007-12-20 14:09:101楼 得分:0
string       strsql       =       "select       *       from       sale_view       where       [date]       between   '"       +       this.datetimepicker1.value.toshortdatestring()+       "       00:00:00     '   and"     +   '"   +datetimepicker1.value.toshortdatestring()       +       "23:59:59'";  
发表于:2007-12-20 17:13:472楼 得分:0
datetime类型的要用''引起来了
发表于:2007-12-21 04:52:443楼 得分:0
1.
string       strsql       =       "select   *   from   sale_view   where   [date]   > ='"+       datetimepicker1.value.toshortdatestring()   +   "   00:00:00'"   and   [date] <='"+       datetimepicker1.value.toshortdatestring()   +   "   23:59:59'";
2.
string       strsql       =       "select   *   from   sale_view   where   [date]   between   '"+       datetimepicker1.value.toshortdatestring()   +   "   00:00:00'"   and   '"+       datetimepicker1.value.toshortdatestring()   +   "   23:59:59'";

这两个都可以.
发表于:2007-12-21 11:18:174楼 得分:0
string   strsql   =   "select       *       from       sale_view       where         dateadd(dd,   0,   datediff(dd,   0,   [date]))         ='"   +   datetime.today.tostring("yyyy/mm/dd",   datetimeformatinfo.invariantinfo)   +   "'";
发表于:2007-12-21 14:06:265楼 得分:0
这不知道   你这包的什么错误  

但很明显   最后一个   判断   时间   拼串的地方   缺了个空格  


快速检索

最新资讯
热门点击