Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Object cannot be cast from DBNull to other type
Message
From
24/05/2013 15:15:06
 
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:
01574646
Views:
49
>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.......
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform