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

Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
======================================
"Randy Galliano" <ra************@thegallianos.comwrote in message news:%2****************@TK2MSFTNGP02.phx.gbl...

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]]

"Randy Galliano" <ra************@thegallianos.comwrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...

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
ASP.NET MVP
http://www.markrae.net

[Randy Galliano]

Randy Galliano wrote:

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]]

"Randy Galliano" <ra************@thegallianos.comwrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...

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...
--
Mark Rae
ASP.NET MVP
http://www.markrae.net