how to fix this " String was not recognized as a valid DateTime"

Question

0.00/5 (No votes)

See more:

Hello,

I'm using radgrid..i have populated the data into that ..now when i click on row in radgrid i need that data in respective textboxes..everything is working fine except date...i have used datetimepicker...date in radgrid row should be displayed in dateimepicker on row click.

This is the code im using and this is the excpetion im getting " String was not recognized as a valid DateTime"
Thank you

protected void RadGrid_Operators_SelectedIndexChanged(object sender, EventArgs e)
        {

 GridDataItem selectedvalue = (GridDataItem)RadGrid1.SelectedItems[0];
 DateTime value = DateTime.Parse(Selectedvalue["date"].Text.ToString().Trim());
 RadDatePicker_Date.SelectedDate = value;
              
         }

Posted 30-Mar-15 3:54am

Member 11148509

Updated 30-Mar-15 3:57am

v5

Add a Solution

Comments

Afzaal Ahmad Zeeshan 31-Mar-15 2:24am

You can fix it by providing a valid DateTime string value.

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

Thanks7872 · Answer 1 · 2015-03-30T04:03:00

Solution 1

Use this : https://msdn.microsoft.com/en-us/library/w2sa9yss(v=vs.110).aspx[^]

Regards..

Posted 30-Mar-15 4:03am

Thanks7872

Comments

Member 11148509 30-Mar-15 11:11am

i want to convert only to date not datetime

Sergey Alexandrovich Kryukov 1-Apr-15 11:56am

Of course; this is expected behavior if you input data is incorrect. Make is consistent and enjoy.
—SA

Sergey Alexandrovich Kryukov 1-Apr-15 11:57am

5ed.

Rohan,

Congratulations with April 1st! :-)

I would like to use the occasion to invite your (and everyone else, of course) to see my new 1 of April publication and have some fun:
Some Programming Approaches to "Neuro-Linguistic Programming".
Participation in this game in Comments and Discussions is especially encouraged.

This time, I put more effort in the work. The fun and mocking is supposed to be combined with quite serious hints, in a satical form, on how we can conduct our discussions, give and use advice, add references and use them, use critical thinking, learn and use our own brains.

Thank you.
—SA

Abhinav S · Answer 2 · 2015-03-30T08:14:00

Solution 3

You can also try DateTime.TryParse[^].

Posted 30-Mar-15 8:14am

Abhinav S

Updated 30-Mar-15 20:22pm

v3

Comments

Member 11148509 31-Mar-15 2:32am

i have tried same error

Sergey Alexandrovich Kryukov 1-Apr-15 11:55am

Of course, because he input data is invalid. You can also use TryParseExact.
—SA

Thanh Xuan Vu · Answer 3 · 2015-03-30T15:53:00

Solution 4

You should use as below:

C#

CultureInfo culture = new CultureInfo("en-US");
DateTime myDate = Convert.ToDateTime(Selectedvalue["date"].Text.ToString(),culture );
RadDatePicker_Date.SelectedDate = myDate;

Hope this help !

Posted 30-Mar-15 15:53pm

Thanh Xuan Vu

Comments

Member 11148509 31-Mar-15 2:29am

din't work same error

Thanh Xuan Vu 31-Mar-15 3:18am

Pls show RadDatePicker_Date.SelectedDate value you expected ?

Member 11148509 31-Mar-15 3:22am

it should show the time which i have given thorugh raddatetime picker ..some date...

Member 11148509 31-Mar-15 3:58am

when i started debugging.. when i hovered my mouse on mydate i can see exact date ...but when i hover my mouse on .text its showing null..

Lucifier Rocks · Answer 4 · 2015-07-03T19:59:00

Solution 5

Data recieved is not a valid date time string even if you try the above options they wont work, use a method to convert the string to supported format i.e. mm/dd/yyyy or yyyy/mm/dd

Posted 3-Jul-15 19:59pm

Lucifier Rocks