Wpf – Need to format dates in dynamically built WPF DataGrid

datagriddatetimeformatwpf

We are binding an unknown result set to a WPF DataGrid at run time. Some of our columns are going to contain DateTime values and we need to properly format these date time fields. Without knowing which columns are going to be DateTime fields at design time, how are we able to format the columns at runtime?

We are using a DataTable's DefaultView to bind to the WPF DataGrid.

Best Answer

Format the binding by StringFormat:

<DataGridTextColumn Header="Fecha Entrada" 
                    Width="110"  
                    Binding="{Binding EnterDate, StringFormat={}\{0:dd/MM/yyyy hh:mm\}}"
                    IsReadOnly="True" />

I think it's better than writing code behind pieces of code

Related Solutions

WPF Datagrid Performance

Since I can't see your source code it is quite hard to help you. Especially since the performance of a WPF application is influenced by a lot of things. For some hints on what to look out for see Optimizing WPF Application Performance. And yes - it greatly matters what xaml is used in each cell. Because usually performance problems do boil down to "too many elements". Did you know that a TextBox are I think 30 individual elements? I recommend you use the Performance Profiling Tools for WPF to find out more about your specific problem. Try to minimize the amount of elements you are using (e.g. by switching from TextBox to TextBlock where appropriate).

Also you have to check if the performance problems exist on any PC you try the application on. Maybe the PC you are using is forcing WPF into software based rendering. Or are you using any BitmapEffects?

Edit:
Looking at your code I would suggest you change

column.Width = DataGridLength.Auto;

to a reasonable fixed width, since the datagrid does not have to recalculate the width dynamically every time something changes (like adding rows, or even scrolling).

R – How to add button dynamically in datagrid in wpf

You could add collapsed (hidden buttons that don't take up space) buttons to the cells and make them visible when needed.

This behaviour also can be bind to some condition with an IValueConverter on the visibility-property.

UPDATE tx to the comment I know there is a build in converter, so here's the deal :

you add a this converter to your window resources

 <Window.Resources>
    <BooleanToVisibilityConverter x:Key="myConverter"/>
  </Windos.Resources>

you use it in your button

<Button   Visibility="{Binding Path=myCondtion,Converter={StaticResource myConverter}}"/>

where myContition is a property you have to create in your class. The value of this property should be true when you want your button to show , or false when you want it to be hidden..

Best Answer

Related Solutions

WPF Datagrid Performance

R – How to add button dynamically in datagrid in wpf

Related Topic