Hi thanks for your reply.
The sp takes datetime in format 'yyyyMMdd HH:mm:ss'
The datetime picket produces a value in format 'dd/MM/yyyy HH:mm:ss'
I just modified the sp to take in a varchar(17) and cast it to a datetime
format.
cheers
Andrew
"Mihai N." wrote:
Quote:
> Quote:
> > my sp takes datetime in 'yyyyMMdd HH:mm:ss' format.
> >
> > however my c# datetimepicker takes 'dd/MM/yy HH:mm:ss' format.
>
> DateTimePicker.Value Property is a DateTime, no need to go thru a
> string and then parse it.
>
>
> --
> Mihai Nita [Microsoft MVP, Visual C++]
> http://www.mihai-nita.net
> ------------------------------------------
> Replace _year_ with _ to get the real email
>