format a date in a repeater

[treyball3]

Ok, so I have a repeater on my aspx page. One of the fields is a date. I want to format this to the shortdate format. The date comes from a database, so it could be null, which is what causes the problem. Here is my code...

<%# iif(not (DataBinder.Eval(Container.DataItem, "DueDate") is System.DBNull.Value), FormatDateTime(DataBinder.Eval(Container.DataItem, "DueDate"), DateFormat.ShortDate), "") %>

I get an error...

"System.InvalidCastException: Cast from type 'DBNull' to type 'Date' is not valid"

I think I know WHY I get this error... its like the second Container.DataItem takes precendence over the iif. Not sure why... and I don't know how to fix it!


But if I simply do

<%# iif(not (DataBinder.Eval(Container.DataItem, "DueDate") is System.DBNull.Value), "1", "2") %>

then I get the results I expect. So, I know the check is working correctly.

Does anyone know how to fix this?

Thanks!



Thanks - Todd

 

[ca8msm]

You shouldn't be performing any logic in the aspx page. Instead, use the code behind page and the data bound event of the repeater.


____________________________________________________________
Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]

Need help finding an answer? Try the Search Facility or read FAQ222-2244.

 

[jmeckley]

I wouldn't go through all this to format a date.
Instead use a DataBound column use set EncodeHTML=false, set the FormatString="{0:MM-dd-yy}" and set the EmptyField="" (or what ever the empty string property is named.)

Jason Meckley
Programmer
Specialty Bakers, Inc.