c# - DataTable to EnumerableRowCollection -

i have datatable according client requirement can contain invalid date "00/00/1999",null,empty string.(typed datset)

when collect them enumerables wish convert of invalid forms empty string.

(i.e)

 enumerablerowcollection<datarow> query =      order in _table.asenumerable()     select     new {         orderdate=          string.isnullorempty(convert.tostring(order.field<datetime>("orderdate"))         ||          (how check date invalid  date)          ? string.empty : order.field<datetime>("orderdate")          } 

how check whether date valid date or not?

datetime.tryparse...like given current code:

 datetime date;  enumerablerowcollection<datarow> query =       order in _table.asenumerable()     select     new {         orderdate=          string.isnullorempty(convert.tostring(order.field<datetime>("orderdate"))         ||          !datetime.tryparse(convert.tostring(order.field<datetime>("orderdate")),out date)          ? string.empty : date.toshortdatestring()          } 

(using notepad ide apologies if there's syntax error should give general idea)

i'm assuming orderdate string since trying assign string.empty, if datetime change ternary assignment datetime.minvalue in place of empty string (or whatever want use "invalid" dates, since empty string no longer option) :

? datetime.minvalue:date 

or if orderdate nullable datetime then

? null:date