question about checking for null in query results

[Kurt Schroeder]

I have a query result set that returns some fields with null length what is
the easiest way to chek for this. This is what i'm trying but it generated a
runtime error:
If (dtrSlb("slbDesc1").IsdbNull()) Then
Else
txtDescription.Text = dtrSlb("slbDesc2")
End If
this returns: Public member 'IsdbNull' on type 'DBNull' not found.
I believe this can be done in VB.NET, but what about here in asp.net?

[Karl Seguin]

if not dtrSlb("slbDesc1") IS DbNull.Value then
txtDescription.Text = dtrSlb("slbDesc2")
end if

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/
"Kurt Schroeder" <Ku***********@discussions.microsoft.com> wrote in message
news:4F**********************************@microsof t.com...

I have a query result set that returns some fields with null length what is the easiest way to chek for this. This is what i'm trying but it generated a runtime error:
If (dtrSlb("slbDesc1").IsdbNull()) Then
Else
txtDescription.Text = dtrSlb("slbDesc2")
End If
this returns: Public member 'IsdbNull' on type 'DBNull' not found.
I believe this can be done in VB.NET, but what about here in asp.net?

[Kurt Schroeder]

Thank You. I knew it had to be something simple.
IOU1
kes

"Karl Seguin" wrote:

if not dtrSlb("slbDesc1") IS DbNull.Value then
txtDescription.Text = dtrSlb("slbDesc2")
end if

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/
"Kurt Schroeder" <Ku***********@discussions.microsoft.com> wrote in message
news:4F**********************************@microsof t.com...

I have a query result set that returns some fields with null length what

is

the easiest way to chek for this. This is what i'm trying but it generated

a

runtime error:
If (dtrSlb("slbDesc1").IsdbNull()) Then
Else
txtDescription.Text = dtrSlb("slbDesc2")
End If
this returns: Public member 'IsdbNull' on type 'DBNull' not found.
I believe this can be done in VB.NET, but what about here in asp.net?