Home / Questions / 273349
Accepted
Hackerman
Asked: 2020-06-20 13:39:18 +0800 CST 2020-06-20 13:39:18 +0800 CST

unhandled exception

  • 772

I have the following table in sql server

enter image description here

From C# I have a form that can edit these fields but I get the following exception but I have other tables with the same code and the same structure and it doesn't come out it only comes out with this one why does this happen

System.FormatException: 'String was not recognized as a valid DateTime.'

enter image description here

Why is this happening ?

enter image description here

c#

1 Answers

  1. Best Answer

    If you parse the error:

    String was not recognized as a valid DateTime

    The value returned from dataGridView1.CurrentRow.Cells[10].Valuedoes not have a suitable format that can be converted to DateTimeusingConvert.ToDateTime(...)

    The string you are trying to convert is "6/19/2019 3:40:00 PM" which would have a format:

    M/dd/yyyy h:mm:ss

    Instead of Convert.ToDateTime(...), I suggest you use DateTime.ParseExact(...)it like this:

      frm.dateFin.Value =  DateTime.ParseExact(dataGridView1.CurrentRow.Cells[10].Value, new string[] { "M/dd/yyyy h:mm:ss tt", "MM/dd/yyyy hh:mm:ss tt" }, CultureInfo.InvariantCulture, DateTimeStyles.None);

    It is important to comment that the formats must be defined:

    M/dd/yyyy h:mm:ss ttand MM/dd/yyyy hh:mm:ss tt, since sometimes you can have 2 digits in the month and two digits in the hour

    • 3