Throws exception String was not recognized as a valid DateTime. Calender extender

Question

0.00/5 (No votes)

See more:

Hi,
I am using calenderExtender on TextBox which pick the date and store it in text box but problem is when i want to store this selected date in Save button click it throws exception
In SQL field i also mention StockDate datetime. On Save button click event i write code:

C#

objBusinessUI.StockDate = Convert.ToDateTime(txtStockDate.Text);

and i also try

C#

objBusinessUI.StockDate = Convert.ToDateTime(txtStockDate_CalendarExtender.SelectedDate);

but it not works
In DAL file

C#

SqlParameter StockDate = new SqlParameter("@StockDate", objStock.StockDate);
                   StockDate.Direction = System.Data.ParameterDirection.Input;
                   StockDate.DbType = System.Data.DbType.DateTime;
                   sqlParams[2] = StockDate;

so please help me
Thnx in advance

Posted 22-Sep-13 20:15pm

indrajeet jadhav

Updated 22-Sep-13 20:19pm

Thanks7872

v2

Add a Solution

4 solutions

Solution 1

I think it is mismatch between the date formats between your dev machine and the sql server machine datetime. Have a look on your computer Regional settings to see your system date time format.

Also use ;

C#

DateTime dt = DateTime.ParseExact(TextBox.Text, "dd/MM/yyyy", 
                                  CultureInfo.InvariantCulture);

Good luck,
OI

Posted 22-Sep-13 20:58pm

Orcun Iyigun

Solution 2

Hi,

txtStockDate_CalendarExtender.SelectedDate might be returning an invalid string format of date time as Convert.ToDateTime takes the string of form mm/dd/yyyy.

Try this.

Posted 22-Sep-13 21:02pm

liveoffedge

Solution 3

Hi Professional

there is some link that help you better.......

http://stackoverflow.com/questions/10570152/string-was-not-recognized-as-a-valid-datetime[^]

http://forums.asp.net/t/1196663.aspx[^]

http://stackoverflow.com/questions/10570152/string-was-not-recognized-as-a-valid-datetime[^]

Happy to Help

Posted 22-Sep-13 21:16pm

Shubh Agrahari

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)

indrajeet jadhav · Accepted Answer · 2013-09-22T21:48:00

Solution 4

objBusinessUI.StockDate = Convert.ToDateTime(txtStockDate.Text.Tostring());

Posted 22-Sep-13 21:48pm

indrajeet jadhav