well as i told you am prand new for using sql
okay okay ..i just want ti select datetime value from my database as selected by end user(my application)
'select * from table where date='"+datetimepicker.value +"''
and datetimepicker.value holds the
value '01'07'2010 12:23:11'
and my date column in db is datetime type

*** actually i tried this
where date =Convert( datetime ,'" + (DateTimePicker1.Value) + "', 102)
but it returns incorrect syntax near '01'07'2010'

what can i do ?? please help mee