[RESOLVED] how to query data in sql base on the date selected by a user in date time picker

[BONITO]

hi Sir,
I care about time and date. example i query from july 12 2018 to july 12 2018, i choose same date from 2 date time picker.
it should return data from morning of July 12 to current time.

and if i query july1 2018 to july 12 2018 thats the time i care about date.
from my query on oracle below it works .

and TEST_START BETWEEN TO_DATE('" + dtpFrom.Value.ToString("yyyyMMdd") + "','yyyymmdd')and to_date('" + dtpTo.Value.ToString("yyyyMMdd 23:59:59") + "','yyyymmdd hh24:mi:ss')

but it not use parameter and i think not support in sql server 2008 . please adviced thanks.