Exception: Specified cast is not valid

Question

Can any1 tell me why the below line throws an exception? if ((DateTime.Now.TimeOfDay.CompareTo(((DateTime)RowSchedule[StartEnter]).TimeOfDay) >= 0) && (DateTime.Now.TimeOfDay.CompareTo(((DateTime)RowTurno[LimiteEnter]).TimeOfDay) <= 0)) The RowSchedule is a DataRow that retrieve the data from a Table from a DataSet. The table have 6 DateTime columns. This is the excepton: System.InvalidCastException Additional information: Specified cast is not valid. Can any1 tell me what is wrong? Thax in advance.

johnbill2004 · Answer

I think the best way is testing whether specified column is DBNull before casting.

Carlos Sanchez · Answer

It's done! I made a mistake. I retrive the data from the table by the Table.Select() method and the filter expression was wrong so that some columns of the DataRow was empty. That's why the line was throwing an exception. Thank you. I appreciate your help n' your time. Regards.

itaym02 · Answer

I am not sure - but this is a place to look: I think the DateTime of C# is a struct different from the dB one. So You can't cast them. There should probably be a method in the DateTime to do the proper transformation.