String was not recognized as a valid datetime

Question

1.00/5 (1 vote)

See more:

An unhandled exception of type 'System.FormatException' occurred in mscorlib.dll

Additional information: String was not recognized as a valid DateTime.

//The error line was this, I use the convert method. Please help//

DateTimePicker1.Text = DataGridView1.CurrentRow.Cells(5).Value

What I have tried:

I am a beginner, I don't know what to do

Posted 13-Dec-21 15:15pm

Sheena Joy Viloria

Updated 13-Dec-21 20:44pm

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Answer 1 · 2021-12-13T17:21:00

Solution 1

It's telling you what the problem is. The string of text you're passing into the DateTimePicker control cannot be converted to a DateTime value.

We can't see the string, and you didn't post it, so...

You have to use the debugger to look at the value of the Cell to see what it contains.

Posted 13-Dec-21 17:21pm

Dave Kreskowiak

OriginalGriff · Answer 2 · 2021-12-13T20:44:00

The problem probably goes deeper than you think: you are getting the value from a DataGridView cell and trying to set it as a DateTime value.

That means that the problem isn;t specifically with that code, but with the data you are processing, and the code which read and writes it from whatever storage you use.

At a guess, you are reading this from a DB into a DataTable and using that as the DataSource for the DGV. And that would mean that you have made a huge mistake - your date / time values in the DB are stored as strings, and they don't contain valid dates on your computer.

So start with the debugger, and look at exactly what is in that cell, and look at where that data comes from: if it is a DB, then you need to change the DB design and all the code that reads or writes to it. If you don't, this problem will come back, and back, and back ...