尝试将日期和时间数据从DataGridView播放到DateTimePicker时，字符串未被识别为有效的DateTime错误(String was not recognized as a valid

尝试将日期和时间数据从DataGridView播放到DateTimePicker时，字符串未被识别为有效的DateTime错误(String was not recognized as a valid DateTime Error when try to sow date and time data into DateTimePicker from DataGridView)

我想从“DateTime”到“DateTimePicker”列显示日期和时间（格式：dd / MM / yyyy h：mm tt 。但它显示错误字符串未被识别为有效的DateTime。

Private Sub dgvSchedule_RowEnter(sender As Object, e As DataGridViewCellEventArgs) Handles dgvSchedule.RowEnter 'DISPLAYS COLUMN VALUE IN TEXTBOXES If e.RowIndex >= 0 Then Dim row As DataGridViewRow row = Me.dgvSchedule.Rows(e.RowIndex) txtID.Text = row.Cells("Patient_ID_Number").Value.ToString dtpDate.Text = row.Cells("Date_Time").Value 'THIS IS WHERE THE ERROR OCCUR txtFirstname.Text = row.Cells("Firstname").Value.ToString txtLastname.Text = row.Cells("Lastname").Value.ToString txtPhoneNumber.Text = row.Cells("Phone_Number").Value.ToString End If End Sub

I want to display Date and time (format: dd/MM/yyyy h:mm tt) from column "DateTime to DateTimePicker. but it shows an error String was not recognized as a valid DateTime.

Private Sub dgvSchedule_RowEnter(sender As Object, e As DataGridViewCellEventArgs) Handles dgvSchedule.RowEnter 'DISPLAYS COLUMN VALUE IN TEXTBOXES If e.RowIndex >= 0 Then Dim row As DataGridViewRow row = Me.dgvSchedule.Rows(e.RowIndex) txtID.Text = row.Cells("Patient_ID_Number").Value.ToString dtpDate.Text = row.Cells("Date_Time").Value 'THIS IS WHERE THE ERROR OCCUR txtFirstname.Text = row.Cells("Firstname").Value.ToString txtLastname.Text = row.Cells("Lastname").Value.ToString txtPhoneNumber.Text = row.Cells("Phone_Number").Value.ToString End If End Sub

最满意答案

“Date_Time”列的格式是什么？

如果是这样的MySQL日期时间： 2016-01-23 23:30:55那么你可以使用VB.NET的DateTime.Parse

Dim new_date As DateTime = DateTime.Parse("2016-01-23 23:30:55") DateTimePicker1.Value = new_date

请注意，格式为“Custom”，CustomFormat为dd/MM/yyyy h:mm tt

DateTimePicker1.Format = DateTimePickerFormat.Custom DateTimePicker1.CustomFormat = "dd/MM/yyyy h:mm tt"

所以最终的代码可能是：

DateTimePicker1.Format = DateTimePickerFormat.Custom DateTimePicker1.CustomFormat = "dd/MM/yyyy h:mm tt" Dim new_date As DateTime = DateTime.Parse(row.Cells("Date_Time").Value.ToString()) DateTimePicker1.Value = new_date

我也注意到你正在使用：

dtpDate.Text = row.Cells("Date_Time").Value

代替

dtpDate.Value = row.Cells("Date_Time").Value

请注意，这些是不同的： 文本和值 。

What is the format of your 'Date_Time' column?

If it's a MySQL datetime like this: 2016-01-23 23:30:55 then you can just use the DateTime.Parse of VB.NET

Dim new_date As DateTime = DateTime.Parse("2016-01-23 23:30:55") DateTimePicker1.Value = new_date

Note that the format is 'Custom' and the CustomFormat is dd/MM/yyyy h:mm tt

DateTimePicker1.Format = DateTimePickerFormat.Custom DateTimePicker1.CustomFormat = "dd/MM/yyyy h:mm tt"

So the final code could be:

DateTimePicker1.Format = DateTimePickerFormat.Custom DateTimePicker1.CustomFormat = "dd/MM/yyyy h:mm tt" Dim new_date As DateTime = DateTime.Parse(row.Cells("Date_Time").Value.ToString()) DateTimePicker1.Value = new_date

I also noticed that you are using:

dtpDate.Text = row.Cells("Date_Time").Value

instead of

dtpDate.Value = row.Cells("Date_Time").Value

Note that these are different: Text and Value.