Exception: Specified cast is not valid

Carlos Sanchez

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.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

johnbill200422y ago
I think the best way is testing whether specified column is DBNull before casting.
0
Carlos Sanchez22y ago
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.
0
itaym0222y ago
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.
0