technomark.in
Hot News

$(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

Asp.Net AngularJS WCF IIS
DataBase Jquery Bikes Random
HomeContact Us Watch Our YouTube Channel ..........Blog Spot..........

Technomark.in

How To Logout From All Devices In Skype

Technomark.in

How To Embed Google Map In Your Code

Technomark.in

How To Install IIS (Internet Information Services) On Windows

Technomark.in

Enable Directory Browsing In IIS

View All


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


When you get this Error?...

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

> 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?...

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

> 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 * Please provide all three fields for posting Comment




Technomark.in

Book Train Tickets on IRCTC Quickly During Tatkal Period

Technomark.in

Before You Copy Any Image From Internet

View All

Privacy StatementDisclaimerSitemap