WPF GridView: Changing the DateTime formatting for bound DataTable

Question

We're using a WPF GridView that is dynamically bound to a DataTable (which in turn is the direct result of a DB query). This basically works fine and displays whatever the results from the DB query are in a nice table.

Now the problem is that some of the results contain DateTime columns, and the date displayed is always in US format and not in the user specified date format.

Is there an easy way to set the datetime formatting for the GridView display?

We don't know beforehand which columns will be DateTime as there are a number of different tables that are displayed.

The way we fill the gridview is as follows:

        MyListView.DataContext = data;
        MyListView.SetBinding(ListView.ItemsSourceProperty, new Binding());
        MyGridView.Columns.Clear();

        foreach (DataColumn col in data.Columns)
        {
            GridViewColumn gvcol = new GridViewColumn();
            gvcol.Header = col.ColumnName;
            gvcol.DisplayMemberBinding = new Binding(col.ColumnName);
            MyGridView.Columns.Add(gvcol);
        }

Jonke · Accepted Answer · 2009-06-26 12:17:34Z

2

It should be enough to put the current culture in the applucation startup

/// <summary>
    /// Interaction logic for App.xaml
    /// </summary>
    public partial class App : Application
    {
        public App()
        {
            FrameworkElement.LanguageProperty.OverrideMetadata(typeof(FrameworkElement), new FrameworkPropertyMetadata(XmlLanguage.GetLanguage(CultureInfo.CurrentCulture.IetfLanguageTag)));

        }
    }

answered Jun 26, 2009 at 12:17

Jonke

6,5532 gold badges30 silver badges40 bronze badges

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

2 Comments

Tom Over a year ago

thanks for the quick reply, this works! now is there also a way to set this later in the application, after showing a login screen, and then setting it not depending on the system language but on a per-user stored language that is returned after login?

Tom Over a year ago

additionaly to the above solution: is there a solution to change the date formatting specifically for the GridView?

Collectives™ on Stack Overflow

WPF GridView: Changing the DateTime formatting for bound DataTable

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related