Unable to cast object of type 'System.DBNull' to type 'System.String'

When you get this Error?...

> We get this error in the following situation.
> When database object returns NULL, "DBNULL", and we try to typecast the result.

Unable To Cast Object Of Type 'System.DBNull' To Type 'System.String', System.InvalidCastException, DBNULL, System.DBNULL, System.String, 'System.String', Unable To Cast Object, Typecast, DBNULL Check, Asp.Net, IIS

> In the above example, you can see, the reader["name"] is returning NULL.
> When we try to typecast to string, we get this error.

How to resolve this issue?...

> We should check whether the database object is NULL before typecasting.
> In the above code, we check whether reader["DBCOLUMN"] is NULL or not.
> After DBNULL check, we can typecast as per our requirement.
> By this way we can resolve this issue.

Watch Video of this Content on Video Streaming

Post Your Comment

Name *

Email *

Comment *

$(this) Selector And Children / Find In jQuery

Detect An Undefined Object Property In JavaScript

Rotate And Save Video Using VLC Media Player

Capitalize The First Letter Of String In JavaScript

Convert Any Files To Any Format Using VLC Media Player

How To Logout From All Devices In Skype

How To Embed Google Map In Your Code

How To Install IIS (Internet Information Services) On Windows

Enable Directory Browsing In IIS

View All