Looping through XmlNodeList

[Raul]

Hi,

I have the following code, which picks up 43 different nodes from my
XML document

XmlNodeList amortNodes = amortDoc.Select Nodes("//
TValueAmortizat ionSchedule/AmortizationLin e");

each node looks like this:

<AmortizationLi neType>8</AmortizationLin eType>
<Date>09/01/2006</Date>
<Loan1Amount>10 0000000</Loan1Amount>
<Loan2Amount> </Loan2Amount>
<Loan3Amount> </Loan3Amount>
<Payment1Amount ></Payment1Amount>
<Payment2Amount ></Payment2Amount>
<Payment3Amount ></Payment3Amount>
<InterestAccrue d>0</InterestAccrued >
<InterestPaid>0 </InterestPaid>
<PrincipalPaid> 0</PrincipalPaid>
<UnpaidInterest Balance>0</UnpaidInterestB alance>
<PrincipalBalan ce>100000000</PrincipalBalanc e>
<TotalBalance>1 00000000</TotalBalance>
<RateChangeRate ></RateChangeRate>
<RateChangeComp ounding>13</RateChangeCompo unding>

Now I am trying to loop through the node list to get get the nodes
with AmortizationLin eType = 8

foreach (XmlNode amortNode in amortNodes)
{
amortType = amortNode.Selec tSingleNode("//AmortizationLin e/
AmortizationLin eType").InnerTe xt;
if (amortType.Equa ls("8"))
{
count++;

...........
}
}

Now I know from my debugging, that not all 43 nodes fulfil this
criteria (ie amortType=8). However, when I run this application, the
amortType always comes back as 8, which seems to tell me it is not
picking up the value? Any ideas?

Thanks for your help.

[Martin Honnen]

Raul wrote:

I have the following code, which picks up 43 different nodes from my
XML document

XmlNodeList amortNodes = amortDoc.Select Nodes("//
TValueAmortizat ionSchedule/AmortizationLin e");

foreach (XmlNode amortNode in amortNodes)
{
amortType = amortNode.Selec tSingleNode("//AmortizationLin e/
AmortizationLin eType").InnerTe xt;

You need/want a relative XPath expression here, relative to amortNode,
so use e.g.
amortType = amortNode.Selec tSingleNode("Am ortizationLineT ype").InnerText ;

If you use // at the beginning of an XPath expression then that is
always an absolute XPath selecting from the root downwards.

--

Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/

[Abbas]

On Mar 20, 1:35 pm, Martin Honnen <mahotr...@yaho o.dewrote:

You need/want a relative XPath expression here, relative to amortNode,
so use e.g.
amortType = amortNode.Selec tSingleNode("Am ortizationLineT ype").InnerText ;

If you use // at the beginning of an XPath expression then that is
always an absolute XPath selecting from the root downwards.

OHHHHhhhhhhhhhh hh, I didnt know that! I'm still getting used to XML
and XPath so I didn't know that the // it would make a difference

Cheers!

[Abbas]

I'm curious, I am trying to make it pick out those with
AmortizationLin eType = 8 right from the XML, hence my node list would
only contain those nodes

So I try this...

amortType =
amortNode.Selec tSingleNode("Am ortizationLineT ype='8'").Inner Text;
But I get this error

System.Xml.XPat h.XPathExceptio n: The expression passed to this method
should result in a NodeSet

[Martin Honnen]

Abbas wrote:

I'm curious, I am trying to make it pick out those with
AmortizationLin eType = 8 right from the XML, hence my node list would
only contain those nodes

So I try this...

amortType =
amortNode.Selec tSingleNode("Am ortizationLineT ype='8'").Inner Text;

amortNode.Selec tSingleNode("Am ortizationLineT ype[. = '8']").InnerTex t
--

Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/

[Abbas]

On Mar 20, 2:10 pm, Martin Honnen <mahotr...@yaho o.dewrote:

amortNode.Selec tSingleNode("Am ortizationLineT ype[. = '8']").InnerTex t

gives this error

System.NullRefe renceException: Object reference not set to an instance
of an object.

[Martin Honnen]

Abbas wrote:

On Mar 20, 2:10 pm, Martin Honnen <mahotr...@yaho o.dewrote:

> amortNode.Selec tSingleNode("Am ortizationLineT ype[. = '8']").InnerTex t

gives this error

System.NullRefe renceException: Object reference not set to an instance
of an object.

Right, as you are looping through elements that might not meet the
condition you need to break that up e.g.
XmlNode amortType = amortNode.Selec tSingleNode(
"AmortizationLi neType[. = '8']");
if (amortType != null) {
Console.WriteLi ne(amortType.In nerText);
}
else {
// no element found
}
--

Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/