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

Question

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

Is that correct??

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

Joe Rätzer · Accepted Answer · 2011-09-20 13:03:33Z

3

DBNull.Value does not equal null.

Try something like:

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

answered Sep 20, 2011 at 13:03

Joe Rätzer

18.6k3 gold badges40 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Binary Worrier · Accepted Answer · 2011-09-20 13:07:31Z

1

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

answered Sep 20, 2011 at 13:07

Binary Worrier

51.8k20 gold badges144 silver badges188 bronze badges

Comments

gbianchi · Accepted Answer · 2011-09-20 13:06:24Z

0

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 :).

answered Sep 20, 2011 at 13:06

gbianchi

2,14827 silver badges37 bronze badges

Collectives™ on Stack Overflow

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

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related