Format values in a Datagrid

Question

Is there any way to format the values that are bound to a datagrid? For example I have the following:

<DataGrid AutoGenerateColumns="False" Height="487" HorizontalAlignment="Left" Margin="12,12,0,0" Name="dgTransactionLog" VerticalAlignment="Top" Width="404">
    <DataGrid.Columns>
        <DataGridTextColumn Binding="{Binding Path=Date}" Header="Date" />
        <DataGridTextColumn Binding="{Binding Path=Payee1.Name}" Header="To/From" />
        <DataGridTextColumn Binding="{Binding Path=Amount}" Header="Amount" />
    </DataGrid.Columns>
</DataGrid>

I'd like the Date column to be just date (not time) and the Amount column to be currency format. Here's how I populate the datagrid:

var transactions = TransactionManager.GetTransactions();
dgTransactionLog.ItemsSource = transactions;

Answer 1

One easiest way. here in the code below use your language code as a value of ConverterCulture. you can find your language code here

<DataGridTextColumn Binding="{Binding Profit, ConverterCulture='gu-IN' ,StringFormat=c}" Header="Profit" Width="*" MinWidth="80" FontWeight="Normal"/>

the output will be in your local currency

for anything other than currency find stringFormat specifier here

Answer 2

Use the StringFormat property:

<DataGridTextColumn Binding="{Binding Path=Date, StringFormat=d}" Header="Date" />
<DataGridTextColumn Binding="{Binding Path=Amount, StringFormat=C}" Header="Amount" />

• Standard Numeric Format Strings
• Standard Date and Time Format Strings