您的位置：程序门 -> .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

这不知道你这包的什么错误

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

其他资讯