How to format DateTime columns in DataGridView?

Question

I'm using a DataGridView with object data binding to display information about logging entities in a system, retrieved via SOAP from a remote service. One of the columns is called "Last action" and means the last time the entity logged a message. It is a System.DateTime value. When I read the SOAP response (example below), he timestamp obviously contains all the information, up to second fractions.

<LoggingEntity>
<host>marty86ce</host>
<process>10148</process>
<logger>http_core</logger>
<appName>httpd</appName>
<ffda>true</ffda>
<lastAction>2010-10-27T12:00:19.5117509Z</lastAction>
<lastHeartbeat>0001-01-01T00:00:00</lastHeartbeat>
<channelId>em_9BA2A2B4D0B6E66</channelId>
<ffdaChannelId>em_E7C8D1D4DE8EEB9</ffdaChannelId>
</LoggingEntity>

When I display it on the table, I instead can read up to the minutes I use the following code to do the data binding when I press the refresh button

public void RefreshEntities()
{
    IEntityManagement management = EntityPlugin.GetProxy();
    LoggingEntity[] result = management.FindLoggingEntities(new TemplateQuery { ffdaSpecified = true, ffda = true }); //Remote invocation

    Invoke(new MethodInvoker(delegate { gridEntities.DataSource = result; })); //THIS does the data binding from the array

    Invoke(new MethodInvoker(delegate { btnRefresh.Enabled = true; }));
}

I would like to know how to control column formatting of data bound values. I think that the format dd/MM/yyyy hh:mm comes from my system's settings. How to override formatting settings programmatically?

Thank you in advance

Full solution code on Subversion (FFDAGui program) for the Logbus-ng open source project.

How to do this in WPF?

Zirui Wang
– Zirui Wang

2017-02-17 06:19:23 +00:00
Commented Feb 17, 2017 at 6:19 — Zirui Wang
– Zirui Wang, Commented Feb 17, 2017 at 6:19

Sarath Subramanian · Accepted Answer · 2016-09-05 09:36:15Z

64

If it is a windows form Datagrid, you could use the below code to format the datetime for a column

dataGrid.Columns[2].DefaultCellStyle.Format = "MM/dd/yyyy HH:mm:ss";

EDIT :

Apart from this, if you need the datetime in AM/PM format, you could use the below code

dataGrid.Columns[2].DefaultCellStyle.Format = "MM/dd/yyyy hh:mm:ss tt";

edited Sep 5, 2016 at 9:36

answered Aug 2, 2016 at 17:07

Sarath Subramanian

21.6k12 gold badges89 silver badges95 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Trevor Vance Over a year ago

What if you don't know which column may or may not contain a datetime? Like a dynamic query tool. How would you dynamically match a date entry and change how it gets formatted?

Doug Kimzey Over a year ago

Format does not show up for DefaultCellStyle in intellisense.

Denis Palnitsky · Accepted Answer · 2010-10-27 12:32:17Z

45

Use Column.DefaultCellStyle.Format property or set it in designer

answered Oct 27, 2010 at 12:32

Denis Palnitsky

18.4k14 gold badges49 silver badges57 bronze badges

Comments

Jla · Accepted Answer · 2010-10-27 12:33:34Z

30

You can set the format you want:

dataGridViewCellStyle.Format = "dd/MM/yyyy";
this.date.DefaultCellStyle = dataGridViewCellStyle;
// date being a System.Windows.Forms.DataGridViewTextBoxColumn

answered Oct 27, 2010 at 12:33

Jla

11.4k14 gold badges65 silver badges85 bronze badges

5 Comments

TFischer Over a year ago

dd/MM/yyyy formats the date as dd-MM-yyyy. Use dd'/'MM'/'yyyy to format the date as dd/MM/yyyy

Appulus Over a year ago

yourColumn.DefaultCellStyle = new DataGridViewCellStyle { Format = "dd'/'MM'/'yyyy hh:mm:ss" };

C4d Over a year ago

Unfortunately it isnt changing anything for me. My date stays as it is. Looks like the date in my column is treated as a string which makes it non-formatable. Are there special requirements to the dates apart from the point, that they are real date-values?

Lorenzo Belfanti Over a year ago

Even for me it does not work, I tried all the ways mentioned here. I'm using BindingSource!

Serenade Over a year ago

im sorry, what is your dataGridViewCellStyle ?

Retchel Obcianal · Accepted Answer · 2016-06-05 12:54:38Z

2

I used these code Hope it could help

dataGridView2.Rows[n].Cells[3].Value = item[2].ToString();
dataGridView2.Rows[n].Cells[3].Value = Convert.ToDateTime(item[2].ToString()).ToString("d");

edited Jun 5, 2016 at 12:54

answered Jun 5, 2016 at 12:49

Retchel Obcianal

212 bronze badges

2 Comments

Moon Cheesez Over a year ago

Could you add some explanation?

galamdring Over a year ago

This is if you are manually populating the rows, and it is desirable for you to convert the DateTime to a String. The ToString("d") specifies the date only format from the DateTime ToString method.

HaveNoDisplayName · Accepted Answer · 2015-03-18 14:45:31Z

1

You can set the format in aspx, just add the property "DateFormatString" in your BoundField.

DataFormatString="{0:dd/MM/yyyy hh:mm:ss}"

edited Mar 18, 2015 at 14:45

HaveNoDisplayName

8,537106 gold badges41 silver badges50 bronze badges

answered Mar 18, 2015 at 14:23

user2953513

692 bronze badges

1 Comment

usr-local-ΕΨΗΕΛΩΝ Over a year ago

There is no such DateFormatString property in System.Windows.Forms.DataGridViewCell

user153923 · Accepted Answer · 2018-08-22 15:12:03Z

1

Published by Microsoft in Standard Date and Time Format Strings:

dataGrid.Columns[2].DefaultCellStyle.Format = "d"; // Short date

That should format the date according to the person's location settings.

This is part of Microsoft's larger collection of Formatting Types in .NET.

answered Aug 22, 2018 at 15:12

user153923

Comments

csabinho · Accepted Answer · 2019-11-17 02:04:31Z

0

string stringtodate = ((DateTime)row.Cells[4].Value).ToString("MM-dd-yyyy");
textBox9.Text = stringtodate;

edited Nov 17, 2019 at 2:04

csabinho

1,6071 gold badge19 silver badges29 bronze badges

answered Nov 16, 2019 at 23:00

user10962728

151 silver badge7 bronze badges

2 Comments

csabinho Over a year ago

Could you please explain why and how this solves the issue?

Tanveer Badar Over a year ago

Should rather set the format string when data binding the column.

Collectives™ on Stack Overflow

How to format DateTime columns in DataGridView?

7 Answers 7

2 Comments

Comments

5 Comments

2 Comments

1 Comment

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

2 Comments

Comments

5 Comments

2 Comments

1 Comment

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related