DBNull

[EyeTalion]

I have a datagrid that gets populated when the page is selected. One of my fields is a date field, so I formated it: Container.DataItem ("Start_Date").ToShortDateString. In the DB this field can be NULL so in my code I check for DBNULL:

<%# IIF(IsDBNull(Container.DataItem ("Display_Start_Date")), "", Container.DataItem,Container.DataItem ("Display_Start_Date").ToShortDateString())%>

I still get this error when a NULL field is returned:

Public member 'ToShortDateString' on type 'DBNull' not found.

any suggestions? is there another way to format the date in a datagrid so it doesn't return the time?

thanks..

[Lord_Rat]

Looks like you got an extra comma in there.

<%# IIF(IsDBNull(Container.DataItem ("Display_Start_Date")), "", Container.DataItem("Display_Start_Date").ToShortDateString())%>