Date Question

[quinnipiac0807]

I have a class that calls a date out of my database. If there's no date in the database I want the field to be blank, but if it's blank it puts 01/01/01 in the field. This is how I'm evaluating it.

if(dr["EstCompDate"].ToString() != String.Empty)
t.dtEstCompDate = Convert.ToDateTime(DateTime.Parse
(dr ["EstCompDate"].ToString()).ToShortDateString());

 

[dalchri]

You might try this instead:

if (!dr.IsDBNull(dr.GetOrdinal("EstCompDate")))

Either way, I would verify that dr["EstCompDate"].ToString() really returns String.Empty for fields that have no date.

This sort of behavior can depend on the DBMS and the connector used.