Default date format of MySql is 'YYYY-MM-DD'
Change your
string date=datetimepicker1.value.tostring("dd-MM-yyyy")
to
string date=datetimepicker1.value.tostring("yyyy-MM-dd")
then try to insert
If you wanted to change the format of a MySQL date from YYYY-MM-DD to MM/DD/YYYY or DD/MM/YYYY format you can use the DATE_FORMAT() function as shown in the example below:
SELECT DATE_FORMAT(CURDATE(), '%d/%m/%Y')
OR
SELECT DATE_FORMAT(CURDATE(), '%m/%d/%Y')