Date formatting in WPF datagrid

Question

I want to change is the date column from a format  quot DD MM YYYY HH MM SS quot  to  quot DD MM YYYY quot      lt DataGrid Name  quot dgBuchung quot  AutoGenerateColumns  quot True quot               ItemsSource  quot  Binding  quot  Grid ColumnSpan  quot 3 quot   gt     lt ab DataGridTextColumn Header  quot Fecha Entrada quot  Width  quot 110 quot           Binding  quot  Binding date  StringFormat    0 dd MM yyyy   quot  IsReadOnly  quot True quot    gt                            lt  DataGrid gt                                          Unfortunately that code throws an XMLParseException  First of all  is this way of solution possible while using AutoGenerateColumns  If no  how else can I try to handle this  If yes  what is the problem with the code above

User · Answer

Very late to the party here but in case anyone else stumbles across this page...

You can do it by setting the AutoGeneratingColumn handler in XAML:

<DataGrid AutoGeneratingColumn="OnAutoGeneratingColumn"  ..etc.. />

And then in code behind do something like this:

private void OnAutoGeneratingColumn(object sender, DataGridAutoGeneratingColumnEventArgs e)
{
    if (e.PropertyType == typeof(System.DateTime))
        (e.Column as DataGridTextColumn).Binding.StringFormat = "dd/MM/yyyy";
}

User · Answer

Binding   Binding YourColumn  StringFormat  yyyy-MM-dd

User · Answer

If your bound property is DateTime  then all you need is   Binding  Property  StringFormat d

User · Answer

first select datagrid and then  go to  properties find Datagrid AutoGeneratingColumn and the double click And then use this code      Datagrid AutoGeneratingColumn object sender  DataGridAutoGeneratingColumnEventArgs e                                if  e PropertyName     Your column name                        e Column as DataGridTextColumn  Binding StringFormat    dd MMMMMMMMM yyyy                   if  e PropertyName     Your column name                        e Column as DataGridTextColumn  Binding StringFormat    dd MMMMMMMMM yyyy                   I try it it works on WPF

User · Answer

I know the accepted answer is quite old  but there is a way to control formatting with AutoGeneratColumns      First create a function that will trigger when a column is generated       lt DataGrid x Name  dataGrid  AutoGeneratedColumns  dataGrid AutoGeneratedColumns  Margin  116 62 10 10   gt    Then check if the type of the column generated is a DateTime and just change its String format to  d  to remove the time part     private void DataGrid AutoGeneratingColumn object sender  DataGridAutoGeneratingColumnEventArgs e                        if YourColumn    typeof DateTime                                 e Column ClipboardContentBinding StringFormat    d

User · Answer

Don t forget to use DataGrid Columns  all columns must be inside that collection  In my project I format date a little bit differently    lt tk DataGrid gt       lt tk DataGrid Columns gt           lt tk DataGridTextColumn Binding   Binding StartDate  StringFormat   0 dd MM yy HH mm ss       gt       lt  tk DataGrid Columns gt   lt  tk DataGrid gt    With AutoGenerateColumns you won t be able to contol formatting as DataGird will add its own columns

User · Answer

This is a very old question  but I found a new solution  so I wrote about it   First of all  is this way of solution possible while using AutoGenerateColumns   Yes  that can be done with AttachedProperty as follows   lt DataGrid AutoGenerateColumns  quot True quot      local DataGridOperation DateTimeFormatAutoGenerate  quot yy-MM-dd quot     ItemsSource  quot  Binding  quot    gt   AttachedProperty There are two AttachedProperty defined that allow you to specify two formats  DateTimeFormatAutoGenerate for DateTime and TimeSpanFormatAutoGenerate for TimeSpan  class DataGridOperation       public static string GetDateTimeFormatAutoGenerate DependencyObject obj    gt   string obj GetValue DateTimeFormatAutoGenerateProperty       public static void SetDateTimeFormatAutoGenerate DependencyObject obj  string value    gt  obj SetValue DateTimeFormatAutoGenerateProperty  value       public static readonly DependencyProperty DateTimeFormatAutoGenerateProperty           DependencyProperty RegisterAttached  quot DateTimeFormatAutoGenerate quot   typeof string   typeof DataGridOperation               new PropertyMetadata null   d  e    gt  AddEventHandlerOnGenerating lt DateTime gt  d  e          public static string GetTimeSpanFormatAutoGenerate DependencyObject obj    gt   string obj GetValue TimeSpanFormatAutoGenerateProperty       public static void SetTimeSpanFormatAutoGenerate DependencyObject obj  string value    gt  obj SetValue TimeSpanFormatAutoGenerateProperty  value       public static readonly DependencyProperty TimeSpanFormatAutoGenerateProperty           DependencyProperty RegisterAttached  quot TimeSpanFormatAutoGenerate quot   typeof string   typeof DataGridOperation               new PropertyMetadata null   d  e    gt  AddEventHandlerOnGenerating lt TimeSpan gt  d  e          private static void AddEventHandlerOnGenerating lt T gt  DependencyObject d  DependencyPropertyChangedEventArgs e                if    d is DataGrid dGrid               return           if   e NewValue is string format               dGrid AutoGeneratingColumn     o  e    gt  AddFormat OnGenerating lt T gt  e  format              private static void AddFormat OnGenerating lt T gt  DataGridAutoGeneratingColumnEventArgs e  string format                if  e PropertyType    typeof T                e Column as DataGridTextColumn  Binding StringFormat   format           How to use View  lt Window    x Class  quot DataGridAutogenerateCustom MainWindow quot     xmlns  quot http   schemas microsoft com winfx 2006 xaml presentation quot     xmlns x  quot http   schemas microsoft com winfx 2006 xaml quot     xmlns local  quot clr-namespace DataGridAutogenerateCustom quot     Width  quot 400 quot  Height  quot 250 quot  gt      lt Window DataContext gt         lt local MainWindowViewModel   gt      lt  Window DataContext gt      lt StackPanel gt         lt TextBlock Text  quot DEFAULT FORMAT quot    gt         lt DataGrid ItemsSource  quot  Binding Dates  quot    gt          lt TextBlock Margin  quot 0 30 0 0 quot  Text  quot CUSTOM FORMAT quot    gt         lt DataGrid          local DataGridOperation DateTimeFormatAutoGenerate  quot yy-MM-dd quot           local DataGridOperation TimeSpanFormatAutoGenerate  quot dd -hh -mm -ss quot           ItemsSource  quot  Binding Dates  quot    gt      lt  StackPanel gt   lt  Window gt   ViewModel public class MainWindowViewModel       public DatePairs   Dates   get      new DatePairs                 new    StartDate  new  2011 1 1   EndDate  new  2011 2 1             new    StartDate  new  2020 1 1   EndDate  new  2021 1 1               public class DatePairs       public DateTime StartDate   get  set        public DateTime EndDate   get  set        public TimeSpan Span   gt  EndDate - StartDate     demo wpf datagrid

[c#] Date formatting in WPF datagrid

Examples related to c#

Examples related to wpf

Examples related to datagrid

Examples related to date-formatting