InfoPath Dev

I have my new form working great except today I ran into an issue with null values.  I thought I was capturing the nulls, but I was wrong.

rdr is my SqlDataReader

if (rdr[EmailID] != null)
                        {

                            //this blows up on this line on the 32nd iteration of the loop when searching for an extended group.
                            EmpNewData.SelectSingleNode("/my:myFields/my:Emp/my:EmpData/my:email", NamespaceManager).SetValue(rdr.GetString(EmailID));
                        }
                        else
                        {
                            EmpNewData.SelectSingleNode("/my:myFields/my:Emp/my:EmpData/my:email", NamespaceManager).SetValue("No.Email");
                        }

Thoughts?

Oh, and yes, the email value is set to NULL in the DB Table. I want to capture this and continue to move on nonetheless.

Thanks

I figured this out.  IsDBNull seems to take care of it.  I ran thru the code in debug to check where the ordinal sat. It was 14 in this case.

int EmailID = rdr.GetOrdinal("EmailID");

Then when using GetString:

if (!(rdr.IsDBNull(14)))
{
     EmpNewData.SelectSingleNode("/my:myFields/my:Emp/my:EmpData/my:email", NamespaceManager).SetValue(rdr.GetString(EmailID));
}
else
{
     EmpNewData.SelectSingleNode("/my:myFields/my:Emp/my:EmpData/my:email", NamespaceManager).SetValue("No Email");
}

I hope this will help somebody :-)

Cheers