How Do I Change Date Format For Particular Column In Data Grid View

Question

0.00/5 (No votes)

See more:

Hi,

I have a requirement where a particular column (Date Time column in DataGridView) is in mm/dd/yyyy (any format) format.

After clicking on a button, it should open another form where it should ask for multiple formats to change (Ex: mm/dd/yyyy to dd/mm/yyyy, mm/dd/yyyy to yyyy/mm/dd, dd/mm/yyyy to mm/dd/yyyy).

After selecting particular format and clicking on submit (Button), the changes should reflect on the column (which is on Form 1).

Please help me on programming this. I would like to get help in C#.net.

Thanks in advance.

Posted 15-Dec-15 2:38am

Member 8010354

Add a Solution

1 solution

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 · 2015-12-15T02:50:00

Solution 1

Use the Column.DefaultCellStyle.Format[^] and also[^] property:

C#

myDGV.Columns["MyDateColumn"].DefaultCellStyle.Format = "dd/MM/yyyy";

Posted 15-Dec-15 2:50am

OriginalGriff

Comments

Member 8010354 16-Dec-15 2:49am

Thank you so much for reply. But i should have multiple options to change the date format irrespective of the format i have. Is it possible?

Ex: Whether i have dd/mm/yy or mm/dd/yy or yy/mm/dd,

I would like to open another form on a button click where i should have all types of formats to convert.

OriginalGriff 16-Dec-15 3:38am

And?
What part of this is a problem?

Member 8010354 16-Dec-15 4:01am

Actually i didn't start coding for that task as i'm completly new to C#.net.
I just fetched the data from a file and reading into datagridview where one of the column is having the date, so i want to change that format.
Is it possible for converting only that column values (Date format) in the grid?

OriginalGriff 16-Dec-15 4:08am

That's what my solution told you how to do...

Member 8010354 16-Dec-15 4:52am

Okay that's perfect. If i have multiple columns with Date, then what i have to do?
Ex: Sent Date, Last Modified Date, Received Date.

Member 8010354 16-Dec-15 4:54am

And moreover, the code which i entered
dataGridView1.Columns["Sent Date"].DefaultCellStyle.Format = "dd/MM/yyyy";

is not working. After i click on that button, nothing is happening.

OriginalGriff 16-Dec-15 5:02am

Set each column Format property.

Member 8010354 16-Dec-15 6:41am

Yeah this works when we are adding columns manually. But in my case, I'm reading a file which contains headers and it's values.
The initial line is Header and rest of the lines are it's values. So how i solve in this case?

OriginalGriff 16-Dec-15 7:00am

Depends how you are reading the file! :laugh:
And I can't access your HDD...

So look at the values you fetch, and how you fetch them.