WPF Datagrid time field format hh:mm

Question

I use a WPF Toolkit Datagrid with a LINQ to SQL

       <my:DataGrid AutoGenerateColumns="False" Name="dataGrid2">
        <my:DataGrid.Columns>
            <my:DataGridTextColumn Header="Date" MinWidth="80"
                                       Binding="{Binding Date, StringFormat=d}"
                                       CanUserSort="False"/>
            <my:DataGridTextColumn Header="Time"  MinWidth="70" 
                                       Binding="{Binding Time}"
                                       CanUserSort="False" />
            <my:DataGridTextColumn Header="Description" MinWidth="200"
                                       Binding="{Binding Description}" 
                                       CanUserSort="False"/>
        </my:DataGrid.Columns>
    </my:DataGrid>

Column Time is bound to a SQL Server table field of a Time datatype. Now time value on the Datagrid is displayed in a format hh:mm:ss.

How could I change a time represantation in the Time column of a Datagrid to hh:mm, removing seconds?

EDIT: Using StringFormat=t gives no result.

<my:DataGridTextColumn Header="Time"  MinWidth="70" 
                                       Binding="{Binding Time, StringFormat=t}"
                                       CanUserSort="False" />

score 9 · Answer 1 · edited Mar 23 '11 at 05:51

9

<toolkit:DataGridTextColumn
                    IsReadOnly="True"
                    Width="SizeToCells"
                    Header="F. Resolución"
                    Binding="{Binding ColName, StringFormat=MM/dd/yyyy}" />

edited Mar 23 '11 at 05:51

Hans Olsson

54,199
15
94
116

answered Mar 22 '11 at 23:38

Alexis Alulema

91
1
2

score 4 · Answer 2 · answered Feb 25 '13 at 08:45

without seconds

<toolkit:DataGridTextColumn
                    IsReadOnly="True"
                    Width="SizeToCells"
                    Header="F. Resolución"
                    Binding="{Binding ColName, StringFormat='MM/dd/yyyy HH:mm'}" />

with seconds

<toolkit:DataGridTextColumn
                    IsReadOnly="True"
                    Width="SizeToCells"
                    Header="F. Resolución"
                    Binding="{Binding ColName, StringFormat='MM/dd/yyyy HH:mm:ss'}" />

here is only time with seconds:

<toolkit:DataGridTextColumn
                    IsReadOnly="True"
                    Width="SizeToCells"
                    Header="F. Resolución"
                    Binding="{Binding ColName, StringFormat='HH:mm:ss'}" />

another solution would be to convert your Timespan ("timespan2 in C# is equal to the "time" dataType in sql server) into DateTime and then try the above solution ! — Farzad J, Feb 20 '14 at 12:11
it worked for me, but how can I make ...StringFormat='HH:mm:ss'}" not present in hundred hours? — Kokombads, Feb 13 '15 at 09:23

score 2 · Accepted Answer · edited May 23 '17 at 11:59

2

Can be done using ValueConverter:

This can help: Built-in WPF IValueConverters

edited May 23 '17 at 11:59

Community

1
1

answered Mar 04 '10 at 06:26

Shoaib Shaikh

4,565
1
27
35

score 0 · Answer 4 · answered Feb 19 '14 at 21:25

You will need to convert your type from SqlDateTime to DateTime in order for the string format to work. Do this by casting your parameter to datetime. So for example when using c# to bring in your table.

dlEntry.StartTime = (DateTime)reader.GetSqlDateTime(3);

This will give you the ability to use the C# default converter for time.

<my:DataGridTextColumn Header="Time"  MinWidth="70" 
Binding="{Binding Time, StringFormat=t}"
CanUserSort="False" />

WPF Datagrid time field format hh:mm

4 Answers4