C# WPF DataGrid - DateTime formatting [duplicate]

Question

I'm using a DataTable (created in code), and I display it's DefaultView using a DataGrid. The DataTable contains a DataColumn that has DateTime as it's DataType.

The DataGrid displays dates as: 10/9/2017 12:00:00 AM. Is there a way to display the DateTime values as 10/9/2017 without changing the column's DataType to string?

Ramankingdom · Accepted Answer · 2017-10-10 11:46:09Z

4

Your Binding should look like this

{Binding Property, StringFormat=d}"

Full example

<DataGridTextColumn Header="Your Header" Binding="{Binding Property, StringFormat=d}" ></DataGridTextColumn>

answered Oct 10, 2017 at 11:46

Ramankingdom

1,4962 gold badges12 silver badges19 bronze badges

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

2 Comments

Njubster Over a year ago

The DataGrid in xaml contains no column definitions, it's just bound to the DataTable's default view. Works perfectly, except for the date display.

Ramankingdom Over a year ago

lets c. gimme some time

mm8 · Accepted Answer · 2017-10-10 13:30:36Z

2

You could handle the AutoGeneratingColumn event for the DataGrid:

private void dg_AutoGeneratingColumn(object sender, DataGridAutoGeneratingColumnEventArgs e)
{
    if (e.PropertyType == typeof(DateTime))
    {
        e.Column = new DataGridTextColumn()
        {
            Binding = new Binding(e.PropertyName) { StringFormat = "d" }
        };
    }
}

answered Oct 10, 2017 at 13:30

mm8

170k10 gold badges71 silver badges102 bronze badges

Collectives™ on Stack Overflow

C# WPF DataGrid - DateTime formatting [duplicate]

2 Answers 2

2 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Linked

Related