convert varchar field in sql database into datetime value while retrieving to display

[muthukumar bala]

DateTimePicker1.Text = reader(Convert.ToDateTime("PURCHASED_DATE"))

this is my code the PURCHASED_DATE field is varchar(50) datatype but when retriving it should be in datetime format

the error is "the string was not recognised as a valid datetime.there is a unknown word starting at index 0
please help me to over come the problem

[Rabbit]

You would need to post the values that it says is not a valid date time value.

[Mikkeee]

Your code is converting the string "PURCHASED_DATE " instead of the reader value. Try this:

  Convert.ToDateTime(reader("PURCHASED_DATE"))