How do one test for nulls in VB?

[Randy Galliano]

Hello,

I am reading some records into a recordset when I got to assign a text
box the value of one of the fields I get an exception because the
recordset has a null value in it. How do you test for nulls in vb script?

Example:

txtModel.Text = SqlDataReader("Manufacturer") '
Manufacturer is null.

Regards,

Randy.

 

[Juan T. Llibre]

If IsDBNull(SqlDataReader("Manufacturer")) Then
txtModel.Text = "N/A"
Else
txtModel.Text = SqlDataReader("Manufacturer")
End If

 

[Randy Galliano]

Hello,

I am reading some records into a recordset when I got to assign a text
box the value of one of the fields I get an exception because the
recordset has a null value in it. How do you test for nulls in vb script?

Example:

txtModel.Text = SqlDataReader("Manufacturer") ' Manufacturer
is null.

Regards,

Randy.

Let me clarify one more thing. I am using .net 2.0 with vb script.
According to the manual on MSDN isNull is a function I can use, but
Visual Studio is saying the function is not defined.

Regards,

Randy.

 

[Mark Rae [MVP]]

Hello,

I am reading some records into a recordset when I got to assign a text box
the value of one of the fields I get an exception because the recordset
has a null value in it. How do you test for nulls in vb script?

Example:

txtModel.Text = SqlDataReader("Manufacturer") ' Manufacturer
is null.

Regards,

Randy.

 

[Mark Rae [MVP]]

How do you test for nulls in vb script?

Assuming that you don't actually mean VBScript, you test for the field being
DbNull.Value...

 

[urstop]

You will have to use something like this
if (SqlDataReader("Manufacturer") = DBNull.value) then
Do whatever for null handling
else
Assign things
end if

Regards,
UrStop