CODEWITHSUNDEEP
exceptionvb.net-2010dbnull
Sandeep K
Sandeep K

Reputation: 43

String.IsNullOrWhiteSpace in vb.net throw error if value is dbnull.value

String.IsNullOrWhiteSpace(valuefromDB) throws error if valuefromDB is dbnull.value

Is that correct??

I thought of this function will also handles the dbnull.value

Upvotes: 1

Views: 2576

Answers (3)

Binary Worrier
Binary Worrier

Reputation: 51711

If you had Option Strict On your code would never have compiled, because the IsNullOrWhiteSpace method on string accepts a string type, DBNull isn't a string type (it's DBNull), and at a guess your valuefromDB variable is of type Object.

The IsNull in the name IsNullOrWhiteSpace is actually referring to the CLRs null which in VB is Nothing, not DBNull

You can either check for both DBNull and IsNullOrWhiteSpace or as pointed out by Emaad Ali, use the VB function IsNothing.

Hope this helps

Upvotes: 1

gbianchi
gbianchi

Reputation: 2138

Yes is correct..

From msdn:

Indicates whether a specified string is Nothing, empty, or consists only of white-space characters.

Nothing is not null, so your string can be nothing or empty, but a dbnull is another different value for it :).

Upvotes: 0

Joe Ratzer
Joe Ratzer

Reputation: 18569

DBNull.Value does not equal null.

Try something like: 

If Not DbNull.Value.Equals(valuefromDB)...

Upvotes: 3

Related Questions