Hi

I am using a oledb reader to read from a table. The problem is that system
generates an exception when MyReader.GetValue(2) returns a value of type
system.dbnull. The system does not allow me to test this expression for
system.dbnull as below;

If objResultClient.GetValue(2) Is System.DBNull Then

How can I check objResultClient.GetValue(2) = System.DBNull for dbnull
value? I have tried objResultClient.GetValue(2) Is Nothing as well but that
does not catch system.dbnull values either.

Thanks

Regards

If objResultClient.IsDBNull(2) Then
// Do your stuff here
End If

/claes

"John" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi
>
> I am using a oledb reader to read from a table. The problem is that system
> generates an exception when MyReader.GetValue(2) returns a value of type
> system.dbnull. The system does not allow me to test this expression for
> system.dbnull as below;
>
> If objResultClient.GetValue(2) Is System.DBNull Then
>
> How can I check objResultClient.GetValue(2) = System.DBNull for dbnull
> value? I have tried objResultClient.GetValue(2) Is Nothing as well but
> that does not catch system.dbnull values either.
>
> Thanks
>
> Regards
>

John wrote:

> How can I check objResultClient.GetValue(2) = System.DBNull for dbnull
> value?

If objResultClient.GetValue(2) Is System.DBNull.Value Then
. . .

HTH,
Phill W.

"John" <(E-Mail Removed)> schrieb:
> I am using a oledb reader to read from a table. The problem is that system
> generates an exception when MyReader.GetValue(2) returns a value of type
> system.dbnull. The system does not allow me to test this expression for
> system.dbnull as below;
>
> If objResultClient.GetValue(2) Is System.DBNull Then

'If ... Is DBNull.Value Then...' or 'If IsDBNull(...) Then...'.

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://dotnet.mvps.org/dotnet/faqs/>