System.InvalidCastException: Specified cast is not valid

Question

I retrieve a table from the database that contains a column of type "time" in sql server, and I try to assign this to a DateTime variable but i get this error: System.InvalidCastException: Specified cast is not valid.

here's my c# code:

DateTime StartTime = (DateTime)dt.Rows[i]["startTime"];

knowing that the column "startTime" is of type "time" and I can change it in the database. any help??

Check out this link. Looks like you need to use a time span. — Devin
– Devin, Commented May 8, 2012 at 20:15
Devin is right. In .NET, SQL Server 2008 time types map to TimeSpan objects. — Icemanind
– Icemanind, Commented May 8, 2012 at 20:23

Marcosvoda · Accepted Answer · 2012-05-08 20:48:19Z

5

DateTime StartTime = Convert.ToDateTime(dt.Rows[i]["startTime"].ToString());

And if you know that it could be null..

DateTime StartTime = (dt.Rows[i]["startTime"] == DBNull.Value ? DateTime.MinValue : Convert.ToDateTime(dt.Rows[i]["startTime"].ToString()));

answered May 8, 2012 at 20:48

Marcosvoda

661 bronze badge

Sign up to request clarification or add additional context in comments.

Comments

James Johnson · Accepted Answer · 2012-05-08 20:40:15Z

4

You should be able to cast it as a TimeSpan:

var startTime = dt.Rows<TimeSpan>("startTime");

answered May 8, 2012 at 20:40

James Johnson

46.1k8 gold badges75 silver badges111 bronze badges

Collectives™ on Stack Overflow

System.InvalidCastException: Specified cast is not valid

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related