Question: How check if datareader is null?

[John Saunders]

"VB Programmer" <growNO-SPAM@go-intech.com> wrote in message
news:eGmnp2MYDHA.1784@TK2MSFTNGP09.phx.gbl...

> I have a datareader that I use in my Try block. In the Finally I want to
> close the datareader, but ONLY if it is not null/nothing. How can I do
> this?
>
> I've tried these already...
> If drReader <> Nothing Then...
> If drReader Is Not Null Then...
> If drReader Is Not System.DbNull Then...
>
> None work. Ideas?

If Not (drReader Is Nothing) Then ...

--
John Saunders
Internet Engineer
[email]john.saunders@surfcontrol.com[/email]

[Ravikanth[MVP]]

Hi

Try this:
finally
' Always call Close when done reading.
if Not (myDataReader is Nothing)
myDataReader.Close()
end if

Ravikanth[MVP]

>-----Original Message-----
>I have a datareader that I use in my Try block. In the

Finally I want to

>close the datareader, but ONLY if it is not

null/nothing. How can I do

>this?
>
>I've tried these already...
> If drReader <> Nothing Then...
> If drReader Is Not Null Then...
> If drReader Is Not System.DbNull Then...
>
>None work. Ideas?
>
>Thanks!
>
>
>.
>

[VB Programmer]

Thanks Ravikanth!

"Ravikanth[MVP]" <dvravikanth@hotmail.com> wrote in message
news:0d7b01c360cf$96eee040$a401280a@phx.gbl...

> Hi
>
> Try this:
> finally
> ' Always call Close when done reading.
> if Not (myDataReader is Nothing)
> myDataReader.Close()
> end if
>
> Ravikanth[MVP]
>
>

> >-----Original Message-----
> >I have a datareader that I use in my Try block. In the

> Finally I want to

> >close the datareader, but ONLY if it is not

> null/nothing. How can I do

> >this?
> >
> >I've tried these already...
> > If drReader <> Nothing Then...
> > If drReader Is Not Null Then...
> > If drReader Is Not System.DbNull Then...
> >
> >None work. Ideas?
> >
> >Thanks!
> >
> >
> >.
> >

[VB Programmer]

Thanks John!

"John Saunders" <john.saunders@surfcontrol.com> wrote in message
news:uzdPK7MYDHA.2632@TK2MSFTNGP09.phx.gbl...

> "VB Programmer" <growNO-SPAM@go-intech.com> wrote in message
> news:eGmnp2MYDHA.1784@TK2MSFTNGP09.phx.gbl...

> > I have a datareader that I use in my Try block. In the Finally I want

to

> > close the datareader, but ONLY if it is not null/nothing. How can I do
> > this?
> >
> > I've tried these already...
> > If drReader <> Nothing Then...
> > If drReader Is Not Null Then...
> > If drReader Is Not System.DbNull Then...
> >
> > None work. Ideas?

>
> If Not (drReader Is Nothing) Then ...
>
> --
> John Saunders
> Internet Engineer
> [email]john.saunders@surfcontrol.com[/email]
>
>