Syntax error (missing operator) in query expression in C#

Question

string sqlStatement = "select ID, Checkintime, RoomPrice, OrderNo from Orders where RoomType='" + selectedRoom.Key + "' and RoomNumber=" + selectedRoom.Value + " and Checkintime>="+dateOnly+" and CheckinTime<'"+endingTime+"'"; 

myAccessCommand = new OleDbCommand(sqlStatement, myAccessConn);
OleDbDataAdapter myDataAdapter = new OleDbDataAdapter(myAccessCommand);
myDataAdapter.Fill(myDataSet, "Orders");

I have syntax error in the SQL statement line but I am not sure what went wrong that caused an syntax exception.

possible duplicate of Syntax error (missing operator) in query expression — Darendal
– Darendal, Commented Aug 3, 2015 at 16:33

Flat Eric · Accepted Answer · 2015-08-03 16:39:10Z

2

Short fix: change

Checkintime>="+dateOnly+"

to

Checkintime>='"+dateOnly+"'

(you forgot the tick marks in the first reference to Checkintime)

Much better: Use a parameterized query

answered Aug 3, 2015 at 16:39

Flat Eric

8,1319 gold badges39 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Syntax error (missing operator) in query expression in C#

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related