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

.htaccess - First slash is removed after domain when entering a webpage in the browser -

Socket.connect doesn't throw exception in Android -

SPSS keyboard combination alters encoding -