How do I solve this line

Question

1.00/5 (1 vote)

See more:

C#

string dateFromtemp = dr["DateFrom"].ToString();
 DateTime dateFrom = DateTime.ParseExact(dateFromtemp, "dd/MM/yyyy", null);

error is- String was not recognized as a valid DateTime.

Posted 30-Jan-14 22:50pm

Member 10548723

Updated 30-Jan-14 22:56pm

Bojjaiah

v2

Add a Solution

Comments

Richard MacCutchan 31-Jan-14 4:53am

What is the content of dateFromtemp?

Bojjaiah 31-Jan-14 4:57am

can you post the result of dateFromtemp?

sp_suresh 31-Jan-14 4:59am

see your system datetime format .For this your application must convert proper datetime format.

3 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)

OriginalGriff · Answer 1 · 2014-01-30T22:57:00

Don't store your dates in your database as strings.

When you do, you get problems like this, because what one user considers the "correct" way to enter dates: 01/30/12 is not valid according to your parese rules: it's US short format. Alternativemy, it could be 30/JAN/12 which also fails.

Store values in databases in the natural format: integer, decimal, or floating point for numbers, and DateTime or Date for dates. Doing anything else wastes space, and causes p[roblem when you try to use them, or read them out.

Pete O'Hanlon · Answer 2 · 2014-01-30T23:08:00

I'm going to guess that the string you are retrieving doesn't match the format dd/MM/yyyy. If, for instance, the date is in American format, you could find that it's storing todays date as 01/31/2014 - as there aren't 31 months in a year, it blows your code apart. If you need a particular format of date from your database, then retrieve it in that format from your query - this assumes that you have stored your date as a DATETIME object in the database and not as a string.

Bernhard Hiller · Answer 3 · 2014-01-30T23:00:00

Solution 2

Assuming that the value was stored in the correct format in the db, do

DateTime dateFrom = (DateTime)dr["DateFrom"];

Posted 30-Jan-14 23:00pm

Bernhard Hiller

How do I solve this line

3 solutions

Solution 1

Solution 3

Solution 2

Add your solution here

Preview 0