Null Exception while reading

ajindal · December 14th, 2004, 03:08 AM

Dear All,

i am facing Null Exception when I try to read from XML Document and no value is assigned.Can any one suggest some function like ISDbNull for reading from Document for specific value.

Thanks

Amit

ChrisScott · December 14th, 2004, 05:15 AM

Hi Amit,

Can you post your code and identify the line where the error occurs?

Thanks,

Chris

ajindal · December 14th, 2004, 06:08 AM

Dear Chris,

Thank you for replying promptly.

I am receving information from XML Document in a stream and is fetching specific information from it using Document Object of type MSXML2.DOMDocument and its method -
.SelectSingleNode("xml...nodes").Text same as we do from Database.

The error "System.NullReferenceException" is generated if I try to read value if the node is empty in XML Document.

I am not able to check by any method if value is empty the same as the method is available for Database ISDBNULL.

Hope to hear soon.

Thanking you in advance.

Regards

Amit

ChrisScott · December 14th, 2004, 06:20 AM

Hi Amit,

You should be able to try to select the element you are after & then check whether you have a node before accessing the Text property, e.g.

Code:

Dim myText: myText = ""
Dim myEl: Set myEl = .SelectSingleNode("xml...nodes")
If Not myEl Is Nothing Then
    myText = myEl.Text
End If

HTH,

Chris