GridCalculatedColumn and DataFormatString

[Andrea Gorin]

I have a GridCalculatedColumn with a datetime expression (returns a timespan), the option DataFormatString don't work!

Why?

                                <telerik:GridCalculatedColumn DataFields="DataOraFineSessione,DataOraInizioSessione" Expression="{0}-{1}"
                                    HeaderText="Durata" UniqueName="Durata" DataType="System.TimeSpan"
                                    DataFormatString="{0:T}">
                                </telerik:GridCalculatedColumn>

I work with the last versione of telerik controls for asp.net 3.5.

Andrea

[Daniel]

Hello Andrea,

As far as I know DataFormatString won't work for TimeSpan objects. Please examine the following link:
Standard Date and Time Format Strings

Best regards,
Daniel
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[Andrea Gorin]

Ok,

Any simple solution to suggest for the question: the differenze for two date ?

Thanks, Andrea  

[Daniel]

Hello Andrea,

For your convenience I created a runnable demo (attached to this post) that shows how can format the TimeSpan manually.

protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
{
    if (e.Item is GridDataItem)
    {
        GridDataItem item = e.Item as GridDataItem;
        TimeSpan myTS = TimeSpan.Parse(item["Durata"].Text);
        item["Durata"].Text = String.Format("{0}h {1}m {2}s", myTS.Days, myTS.Hours, myTS.Minutes);
    }
}

<telerik:GridCalculatedColumn DataFields="DataOraFineSessione,DataOraInizioSessione"
    Expression="{0}-{1}" HeaderText="Durata" UniqueName="Durata" DataType="System.TimeSpan">
</telerik:GridCalculatedColumn>

I hope this helps.

Best regards,
Daniel
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.