How to format DateTime in a DataGridView

Question

3.00/5 (1 vote)

See more:

Hi all,

I have a DataGridView control and its DataSource property is bound to a table received from an MS-SQL query. All of the data types in the bound table are smalldatetime.

After I receive the table, I want to display the data as "dd-mm-yyyy" rather than "mm-dd-yyyy".

Any suggestions?

Thanks.

Posted 21-Nov-09 3:33am

shayke23

Updated 6-Jul-20 18:54pm

Nish Nishant

v2

Add a Solution

6 solutions

Solution 1

Perhaps Googling on String.Format() would give you an idea?

Posted 21-Nov-09 5:12am

Oakman

Solution 4

CSS

You can try this:
dataGridView1.Columns[0].DefaultCellStyle.Format = "dd/MM/yyyy";
Hope this will help you.

Posted 16-May-11 22:36pm

DengOne

Comments

Tamil Arasu K 19-Jul-14 8:15am

in my grid have some null values in date field at that time this format is not working... how can i resolve this problem?

Solution 3

thx 4 ur help guys!

eventually i used:

c[column_index].DefaultCellStyle.Format = "dd-MM-yyyy";

for each column i wanted to format.

thx again!!!

Posted 21-Nov-09 13:45pm

shayke23

Solution 5

This can help

Dim xRowCount As Integer = 0
Do Until xRowCount = xDataGrid.RowCount
xDataGrid.Rows(xRowCount).Cells(2).Style.Format = Format("dd-MMM-yyyy")
xRowCount = xRowCount + 1
Loop

Posted 4-Jun-14 21:18pm

Rakesh_Sharma23

Comments

CHill60 5-Jun-14 4:39am

You do realise that the OP posted the solution they used over 4 and a half years ago!

Solution 6

For SQL Convert(varchar(20), ColumnName, 20) AS ColumnSameName

I use this to import data to a datagridview in c# format the date at query and display the datetime

Then I get that information and export to a CSV - Otherwise the format will show dd/mm/yyyy HH:mm tt

Result:

yyyy-MM-dd HH:mm:ss

2014-11-21 02:03:04

Posted 21-Nov-14 8:10am

Josue Valentin

Comments

CHill60 22-Nov-14 7:18am

You're trying to answer a 5 year old question

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)

avnish kumar maddheshiya · Accepted Answer · 2009-11-21T08:17:00

Solution 2

Add Dataformatstring="dd-MM-yyyy" in bound field column

Posted 21-Nov-09 8:17am

avnish kumar maddheshiya