开发者

Syntax error (missing operator) in query expression

开发者 https://www.devze.com 2023-01-30 10:01 出处:网络
I am working with C# Form based application with Access as DB. And getting this error Syntax error (missing opera开发者_开发技巧tor) in query expression \'Request_Data = 12/15/2010 12:00:00 AM AND U

I am working with C# Form based application with Access as DB.

And getting this error

Syntax error (missing opera开发者_开发技巧tor) in query expression 'Request_Data = 12/15/2010 12:00:00 AM AND User_ID = '1''.

On this query.

String sql = "Select * From Requests WHERE Request_Data = 12/15/2010 12:00:00 AM AND User_ID = '1'";

What's wrong in this query?


I'm guessing you need quotes hashes around the datetime:

String sql = "Select * From Requests WHERE Request_Data = #12/15/2010 12:00:00 AM# AND User_ID = '1'";

0

精彩评论

暂无评论...
验证码 换一张
取 消