converting dd/mm/yyyy to mm/dd/yyyy in asp.net

Question

0.00/5 (No votes)

See more:

i want to convert dd/mm/yyyy date format to mm/dd/yyyy . In my form i want to show the date to user in dd/mm/yyyy for that i have done:

C#

protected void Calendar1_SelectionChanged(object sender, EventArgs e)
   {
       TextBox2_PopupControlExtender.Commit(Calendar1.SelectedDate.ToString("dd/MM/yyyy"));
   }

But as we know that database accepts date in mm-dd-yyyy, so on executing my project error is generated:

Quote:
String was not recognized as a valid DateTime.

I heard it somewhere that i had to split the date first and then change it to mm-dd-yyyy but don't know how to do it. Thanx.

Posted 2-Jul-13 23:38pm

Rambo_Raja

Add a Solution

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 · 2013-07-02T23:50:00

Databases don't "accepts date in mm-dd-yyyy", they expect ISO format "yyyy-MM-dd" but will work with others if they have to.

Instead of passing string dates around, use parametrized queries to pass DateTime objects instead - it's safer, because strings are always vulnerable to SQL Injection attack, and easier because it doesn't require you to convert DateTime to string and back again at any time. Formatting a date to a string should only be done at the last moment for presentation to the user, just as strings should be converted to datetime values as soon as possible - that way, you can let teh user have his data in the format he is used to, and has his computer set to.

_Amy · Answer 2 · 2013-07-02T23:43:00

Solution 1

This may help you:

C#

DateTime.ParseExact(TextBox2.Text.Trim(), "dd/MM/yyyy", null).ToString("MM/dd/yyyy");

Check this[^] for more details.

--Amit

Posted 2-Jul-13 23:43pm

_Amy

Updated 2-Jul-13 23:44pm

v2

Comments

Rambo_Raja 3-Jul-13 6:03am

cannot implicitly convert type string to system.datetime. This error is coming when using your code..

pjaar89 · Answer 3 · 2013-07-03T00:01:00

Solution 3

An ugly solution but it works?

C#

s = s.Split("/")(1) + "/" + s.Split("/")(0) + "/" + s.Split("/")(2);

Posted 3-Jul-13 0:01am

pjaar89