I have a situation where I am looping through a datareader's rows. An
exception is being generated when I attempt to check the value of a Boolean
field where it has a null value:\

If VarType(dtrList["ServiceCenter"]) != VariantType.Null And
dtrList["ServiceCenter"] = True Then

chkAssignedGroups.Items[0].Selected = True

End If

What is the correct way to do this?



Thanks,

Ron

RSH wrote:
> I have a situation where I am looping through a datareader's rows. An
> exception is being generated when I attempt to check the value of a Boolean
> field where it has a null value:\
>
> If VarType(dtrList["ServiceCenter"]) != VariantType.Null And
> dtrList["ServiceCenter"] = True Then
>
> chkAssignedGroups.Items[0].Selected = True
>
> End If

Wow, and I thought *I* was bad at remembering what language I was using
So which is it?

--
Larry Lard
Replies to group please
When starting a new topic, please mention which version of VB/C# you
are using

if (!(dataReader.IsDBNull(0)))
{
currentOrder.CustomerID = dataReader.GetString( 0);
}


Its C#, but the property of IsDBNull (int) should be the same.







"RSH" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I have a situation where I am looping through a datareader's rows. An
> exception is being generated when I attempt to check the value of a
Boolean
> field where it has a null value:\
>
> If VarType(dtrList["ServiceCenter"]) != VariantType.Null And
> dtrList["ServiceCenter"] = True Then
>
> chkAssignedGroups.Items[0].Selected = True
>
> End If
>
> What is the correct way to do this?
>
>
>
> Thanks,
>
> Ron
>
>
>
>
>
>