date - Sql Datetimepicker format error -


kmt.parameters.addwithvalue("@car_date", datetimepicker1.text); 

car_date date type column , it's format yy-mm-dd

but datetimepicker format dd.mm.yy

how can fix this?

assign datetimepicker.value.date parameter - not .text string!

kmt.parameters.addwithvalue("@car_date", datetimepicker1.value.date); 

the date sql server (assuming have sql server) has no format - it's 8-byte binary data.


Comments

Popular posts from this blog

SPSS keyboard combination alters encoding -

Socket.connect doesn't throw exception in Android -

iphone - How do I keep MDScrollView from truncating my row headers and making my cells look bad? -