SQL Server 2008 Time column messing up GridView DataFormatString

Question

I've got a nullable column in SQL Server 2008 that I use to store a time. When I use LINQ to SQL and pull data back it comes back as TimeSpan?. When I bind that to a GridView and try to format it using DataFormatString="{0:t}" it still shows the seconds. Any thoughts?

Answer 1

Make sure you also disable Html encoding for your format to work.

HtmlEncode="false"

Answer 2

The problem is that TimeSpan doesn't implement IFormatable. So you can't directly format TimeSpans.