how to change datagridview column date format?

Question

0.00/5 (No votes)

See more:

How can I change date format from us format(mm/dd/yy)to(yy/mm/dd)in a date column from a datagridview.It's possible to change settings in controlpanel>regional settings for each computer,but i want do that programmatically,i meant that whenever the user opens form,change automatically,thanks.

Posted 25-Jan-11 10:42am

maysam_p82

Add a Solution

3 solutions

Solution 1

Try Below:

DateTime d=DateTime.parse("01/25/2011");
d. ToString("yy/MM/dd");

Posted 25-Jan-11 10:48am

ravitechguy

Updated 25-Jan-11 10:52am

v2

Solution 2

You cannot change the 'date format' of the column.

What you can do is handle the OnCellFormatting[^] event of your DataGridView.

What this event does is allow you to take the actual value contained by a cell and change what actually gets displayed. So if the value of a cell is 10 you can actually display "bananas", without breaking your application.

If you follow the link above, the code on that page shows how to format dates.

Posted 25-Jan-11 12:47pm

Henry Minute

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)

Theingi Win · Accepted Answer · 2011-01-25T14:36:00

Solution 3

You should change your datagridview date column Default cell style

datagridview .Columns[0].DefaultCellStyle.Format = "yy/mm/dd";

Posted 25-Jan-11 14:36pm

Theingi Win

Updated 25-Jan-11 14:51pm

v2

Comments

Henry Minute 25-Jan-11 21:24pm

Good call!

Theingi Win 26-Jan-11 6:49am

:)

maysam_p82 26-Jan-11 3:54am

Thank you very much sir,you are great:**.my problem solved...

Theingi Win 26-Jan-11 6:49am

Your welcome!

deepak_program 26-May-11 0:23am

Thank you sir for your valuable information