VB + SQL (Accept date input from user for search)
Adodc1.RecordSource = "SELECT * FROM cm1 WHERE dt>=#1/1/2011 02:00:00 AM# AND dt<=#4/1/2011 02:00:00 PM#"
for searching a database using VB !
please let me know if there is a way to accept input from the user in a text box and use thm instead of the constant values that i have used
|All times are GMT +5.5. The time now is 00:37.|