Re: Null Value with Repeating table Error

SeanPRyan — Fri, 08 Jun 2012 13:44:07 GMT

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

Null Value with Repeating table Error

SeanPRyan — Thu, 07 Jun 2012 18:48:47 GMT

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

Code

Re: Null Value with Repeating table Error

Null Value with Repeating table Error