how to convert a string to a datatimepicker box

Question

i have a datetimepicker box on a form that gets its value from a datagrid (only date) i am trying to assign the string date value from the grid to the datetimepicker box, but is not working

Answer 1

You may want to start here: http://www.exforsys.com/tutorials/vb.net-2005/common-windows-form-controls-section-2.html

But essentially, do a check to validate your string is a date (IsDate(object) Returns Boolean), Convert the String to a Date (CDate(String)) and then assign the DateTimePicker.Value to the converted string.

Answer 2

if your Cell has a custom Format, then use:

Dim DateValue = Date.ParseExact(Str, YourCustomFormat, Nothing)