Error Conversion failed when converting date and/or time from character string

[drako_darpan]

Hola que tal, en VB casi no lo e usado, pero en C# seria algo asi:

sFecha = DateTimePicker1.Value.Year.ToString() + "-" + DateTimePicker1.Value.Month.ToString().PadLeft(2, '0') + "-" + DateTimePicker1.Value.Day.ToString().PadLeft(2,'0' );

Y eso lo mandas al SP.