You have to insert in to MM/dd/yyyy formate and fetch data using dd/MM/yyyy format.
cmd = New SqlCommand("insert into test values( '" & Format(CType(DTPDT.Text, Date), "MM/dd/yyyy") & "' )", con)
cmd.ExecuteNonQuery()
for view in dd/MM/yyyy format.
Format(CType(DateTimePicker1.Text, Date), "dd/MM/yyyy")