3 replies to this topic

[Orush7]

Hi there,
I'm new here and I'm pretty much a newbie so I hope you could help me...

I need to compare a datetime from a datebase to a date from DateTimePicker in order to get a datatable only with dates after the specific DateTimePicker date. (Ugh I really dont know how to explain it, I hope you got me. If you didnt just say and I'll try to give a wider explanation)

How can I write it correctly in SQL?

WHERE Date>'???'

Thanks in advance!

[WingedPanther]

It depends a little on the database type. Oracle handles dates differently from SQL Server, which is different from MySQL...

[Orush7]

I have SQL Server


Thanks

[sam_coder]

in ADO.NET
in your query instead of trying to concat in a date value, you use
@datefieldname

Then in your code, you want to add

command.Parameteres.AddWithValue("@datefieldname", datetimepicker.Value);

i might be wrong on the .Value, I havent used one (Date Time Picker) in recent memory

but this way, in your code, you dont need to worry about qualifiers, you can just treat the parameter as a SQL declare

Edited by sam_coder, 15 January 2011 - 08:02 AM.
clarifying