Checking for a null value in a datareader

  • Thread starter Thread starter RSH
  • Start date Start date
R

RSH

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 said:
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
Click to expand...

Wow, and I thought *I* was bad at remembering what language I was using
:) So which is it?
 
if (!(dataReader.IsDBNull(0)))
{
currentOrder.CustomerID = dataReader.GetString( 0);
}


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