Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Object cannot be cast from DBNull to other type
Message
 
 
To
All
General information
Forum:
ASP.NET
Category:
Coding, syntax and commands
Title:
Object cannot be cast from DBNull to other type
Environment versions
Environment:
C# 4.0
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01574643
Message ID:
01574643
Views:
64
Hi everybody,

I am getting this error

"Object cannot be cast from DBNull to other types"

on this piece of code:
start_time = Convert.ToDateTime((row["start_time"] ?? DTSqlMinDate));
As you see here, I attempt to use C# coalesce operator in order to avoid this error, but it doesn't work. How should I correct this error without introducing extra nullable datetime variable?

Thanks in advance.

UPDATE. This seems to fix the problem
Convert.ToDateTime((row["start_time"]== DBNull.Value)?DTSqlMinDate:row["start_time"]);
If it's not broken, fix it until it is.


My Blog
Next
Reply
Map
View

Click here to load this message in the networking platform