Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Object cannot be cast from DBNull to other type
Message
 
 
General information
Forum:
ASP.NET
Category:
Coding, syntax and commands
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:
01574647
Views:
42
>>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"]);
>
>I think you were confusing DBNull with C# null which is what the ?? operator uses.......

I thought the above would prevent the problem. Is there any other way to fix it besides my solution?
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform