How do you assign null value to optional parameters in VB.NET 1.1

Question

I tried DbNull.Value but no luck. How do I assign a default value as null to a string parameter that is null in VB.NET? Its litte strange to see that VB does not have anything like plain null as most of the other languages do. Also what is the difference between null and DbNull and Nothing. Thanks Guys.

score 5 · Accepted Answer · answered Dec 21 '10 at 16:06

5

Nothing is what you use in VB for null, so VB has no null, and DBNull is to be used to pass null to database when, for example, you are constructing a call to stored procedure and one of its input parameters needs to be null.

answered Dec 21 '10 at 16:06

Michael Sagalovich

2,539
19
26

score 2 · Answer 2 · answered Dec 21 '10 at 16:06

2

VB.Net's closest equivalent to null is Nothing.

Note that this isn't a direct analog to C#'s null, but rather a closer match for C#'s default(T). However, it should do what you need here.

answered Dec 21 '10 at 16:06

Joel Coehoorn

399,467
113
570
794

Thanks Joel (and others too). – Tintin Dec 21 '10 at 20:23

score 1 · Answer 3 · answered Dec 21 '10 at 16:06

1

use nothing instead of null

answered Dec 21 '10 at 16:06

Geoff Appleford

18,538
4
62
85

How do you assign null value to optional parameters in VB.NET 1.1

3 Answers3