DateTime syntax help

[Branislav Vidovic]

Hello guys.. Looks like I just need a litle help on my SQL syntax in C#.NET I have a field in my database which is DateTime type. Looks like I can't get the syntax right for comparing the value from the textBox with the field in database. Now what I have looks like: DateTime ShDate = DateTime.Parse(txtDate.Text); cmd1.CommandText = "SELECT ShipedDate FROM Details WHERE Details.ShipedDate = #ShDate#"; When I fill dataset with the adapter which has this SelectCommand it will report error in date in the syntax expresion. Now the variable ShDate has a DateTime type in C# and it stores a date from the textbox with a help of conversion and it is in a correct format(I cheked while debuging). I think the problem is somewhere here = #ShDate#. I bet I am missing some quotation marks ("") or single quote(''). So does any one have a clue? Thanks..

[Senu Gandhi]

Hi, I think you are just now migrating from MS-Acccess. When comparing date in SQL Server no need of "#". Just simply " = ShDate " is enough. Senthil

[edukulla]

Can you try this out... DateTime ShDate = DateTime.Parse(txtDate.Text); cmd1.CommandText = 'SELECT ShipedDate FROM Details WHERE Details.ShipedDate =%' + ShDate + '%'; See if it helps. Thanks! Santhosh

Santhosh Kumar Edukulla

[edukulla]

Apologies, ignore my previous post.. Try this DateTime ShDate = DateTime.Parse(txtDate.Text); cmd1.CommandText = 'SELECT ShipedDate FROM Details WHERE Details.ShipedDate like' + '''' + '%' + ShDate + '%' + ''''; I tried it on my sql box and it worked. Hope this helps Thanks!

Santhosh Kumar Edukulla