[Solved] Binding: Display null value for DateTime.MinValue

[James Pearson]

I'm binding the RadGrid from a collection of business objects.  Some date/time properties, which are null in the database, are set to DateTime.MinValue.  These display as 01/01/0001 12:00:00 AM in the grid.  What's the recommended approach to displaying these as null value (i.e. no value displays in grid)?

[Daniel]

Hello James,

You could use a GridTemplateColumn to achieve this functionality:

<telerik:GridTemplateColumn>
    <ItemTemplate>
        <%# (Eval("Date") == DBNull.Value)?"no date": Eval("Date") %>
    </ItemTemplate>
</telerik:GridTemplateColumn>

Let me know whether this approach is suitable for your scenario.

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.