sql server - Why does my SQL query fail when I use quotes? -

hi want write sql query in mvc4? explain issue clearly

sql query

 select * view_visitorsform  visitingdate>='' , visistingdate<='' 

i tried write query in controller getting error. donno perfect syntax use in controller. error mentioned in below image.

please 1 tell me correct solution problem.

advance thanks.

i think looking following:

sqlcommand cmd = new sqlcommand("select * view_visitorsform visitingdate between " + fromdt + " , " + todt + "",con);