How to convert string into datetime

Question

Using VB.Net

When i click the gridview column, that selected column items should appear in the datetime picker

GridView Column value is string, datetime picker datatype is datetime

Code

 Private Sub gridview1_CellContentDoubleClick(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles gridview1.CellContentDoubleClick
        Dim i As Integer
        i = gridview1.CurrentRow.Index
        Dim dt As String = gridview1.Item(1, i).Value
        datetimepicker1.value = CDate(dt)
 End Sub

When i clicked the gridview column, it is showing error as "Conversion from string "25/09/2011" to type 'Date' is not valid"

How to solve the above problem

Need VB.Net Code Help....

Kevin Hogg · Accepted Answer · 2011-12-06 01:43:05Z

2

This problem is related to locale settings in that the CDATE() function expects date values to be provided in the following format: MM/DD/YYYY (MM = Month, DD = Day, YYYY = Year). This means the code fails in the UK which is DD/MM/YYYY. Passing 25/09/2011 is translated to:

Month = 25
Day = 09
Year = 2011

If the value you're using is a string you'll need to parse the string value to extract the correct values before passing it to the CDate() function:

Private Sub gridview1_CellContentDoubleClick(ByVal sender As System.Object, _
    ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) _
    Handles holidaygrid.CellContentDoubleClick

    textbox1.Text = DateTime.ParseExact( _
        gridview1.Item(1, gridview1.CurrentRow.Index).Value, _
            "dd/MM/yyyy", CultureInfo.InvariantCulture).ToString()

 End Sub

edited Dec 6, 2011 at 1:43

answered Sep 27, 2011 at 9:15

Kevin Hogg

1,78125 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Luke Girvin · Accepted Answer · 2011-09-27 09:03:07Z

1

If you know which date format to expect in advance, use DateTime.ParseExact, e.g.:

datetimepicker1.Value = DateTime.ParseExact(dt, "dd/MM/yyyy", CultureInfo.InvariantCulture)

answered Sep 27, 2011 at 9:03

Luke Girvin

13.5k10 gold badges69 silver badges87 bronze badges

Collectives™ on Stack Overflow

How to convert string into datetime

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related