date comparision problem in vb.net project

[ajay bharti]

hi, i have to set timer in my windows application. if date of set_timer column in database is equal to system date time then a beep should be generated. i am unable to write exect code for retrieving that perticular date where set_timer= system.datetime.now() i had write sql query in adapter, all were failed to get data from data set. select * from case_details where (set_timer= dt) select * from case_details where (set_timer= 'dt') select * from case_details where (set_timer= '&dt&') where dt was declared as dim dt as system.datetime dt= datetime.now() i had also use convert function as select * from case_details where (set_timer= CONVERT(DATETIME,dt,102)) it is also not woking plz help me. hi this ajay bharti

[Christian Graus]

A datetime runs right down to the millisecond. You need to make your query so that it has less granularity, by either stripping info from all datetimes you store ( for example, set all milliseconds to zero ), or by using a range in your query. Christian Graus - Microsoft MVP - C++