How to format date time in datagridview in windows application

Question

1.00/5 (1 vote)

See more:

Hi Everyone Hope you are fine...
I am building a windows application and face a problem into it. when i populate the DataGridView the Date format show me like "12/12/2017 12:00:00" along with time what i want to do here is i want to display only date in "DD/mm/yyyy" format except time what i will have to do kindly post some suggestions... thankx in advance

What I have tried:

the following code do not work for me:

dataGrid.Columns[2].DefaultCellStyle.Format = "MM/dd/yyyy"

Posted 16-Mar-17 0:13am

Muhammd Aamir

Updated 16-Mar-17 0:26am

Add a Solution

Comments

Graeme_Grant 16-Mar-17 6:15am

Google Search has a ton of answers for you: How to export datatable to xls file in C#[^]

Muhammd Aamir 16-Mar-17 6:18am

i have tried a lot nothing goes fine

Graeme_Grant 16-Mar-17 6:19am

Did you click on the link provided? I had a look and there are valid answers. Would you like me to copy and paste one for you?

Muhammd Aamir 16-Mar-17 6:21am

ya please do

Graeme_Grant 16-Mar-17 6:21am

This link offers two different solutions: .net - C# DataGridView date time formatting of a column - Stack Overflow[^]

Muhammd Aamir 16-Mar-17 6:25am

@Graeme_Grant thank you i have done it now

Graeme_Grant 16-Mar-17 6:27am

Next time make the effort and do the research like I just did. It is not rocket science.

Muhammd Aamir 16-Mar-17 6:30am

cheers nd thankx

CHill60 16-Mar-17 6:17am

How are you populating the DataGridView?

Muhammd Aamir 16-Mar-17 6:19am

using sql query

CHill60 16-Mar-17 6:23am

Not helpful - I sort of need to see the code. You've also tagged this question as ASP and GridView but are referring to windows and DataGridView - which is it??

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 · Accepted Answer · 2017-03-16T00:25:00

Solution 1

When I try that with a dataGridView, it works fine, provided the date information I have loaded into the DGV data source is actually a DateTime value: if it's a string representation of a date, then it can't do anything with it.

Check your data source: if it's a DB, make sure that the source column is DATE or DATETIME and that you don't format it with a CONVERT when you retrieve the information.

Posted 16-Mar-17 0:25am

OriginalGriff

Comments

Muhammd Aamir 16-Mar-17 6:28am

thanks sir i appreciate your knowledge...

OriginalGriff 16-Mar-17 6:36am

You're welcome!