SelectSingleNod e always selects same node when looping through

[Claire Reed]

Dear All,

I am repeatedly encountering a problem whilst looping through XML
Nodes and I am unsure as to what is going on and how I can get around
it.

I load the following XML document into an XmlDocument object using
LoadXml:

<?xml version="1.0" encoding="UTF-8"?>
<Templates>
<Template Filename="NON.R TN.FORMA3.xml">
<SQLCommand>SEL ECT Addresses.Addre ss_Line1, Addresses.Addre ss_Line2,
Addresses.Addre ss_Line3, Addresses.Addre ss_Line4, FROM
Addresses</SQLCommand>
</Template>
<Template Filename="ERChi ld.NON.RTN.xml" >
<SQLCommand>SEL ECT Addresses.Addre ss_Line1, Addresses.Addre ss_Line2,
Addresses.Addre ss_Line3, Addresses.Addre ss_Line4, Addresses.Postc ode
FROM Addresses</SQLCommand>
</Template>
</Templates>

XmlDocument xdTemplateInfo = new XmlDocument();
xdTemplateInfo. LoadXml(strJobX ml);

(strJobXml contains the Xml as above). I then would like to retrieve
the SQLCommand for a Template whose filename attribute is the same as
my search string (strSearchFile) . I thought that I could do this as
follows:

XmlNodeList xlTemplates =
xdTemplateData. SelectNodes("Te mplates/Template");
foreach (XmlNode xnTemplate in xlTemplates)
{
if (xnTemplate.Att ributes.GetName dItem("Filename ").InnerTex t ==
strSearchFile)
{
//retrieve the SQL
//TODO: the following statement appears to always return the first
//matching node of the document!
XmlNode xnSql = xnTemplate.Sele ctSingleNode("/Templates/Template/SQLCommand");
strSQLCommand.A ppend(xnSql.Inn erText);
break;
}
}

However, even though xnTemplate refers to a SingleNode in xlTemplates
(the list of Template nodes) the SelectSingleNod e operation always
returns the first matching SQLCommand element in the XmlDocument i.e.
the SQL Command for the template with filename NON.RTN.FORMA3. xml. I
would like to know why the SelectSingleNod e does not apply to the
current node but the whole document and, is there a way to select a
sub-node of a current node?

many thanks

Claire

[Jerry Pisk]

Because your XPath expression starts with /, which takes the context all the
way to the root node and runs the selection from that context. If you want
to select SQLCommand node that's a child of xnTemplate then you need to
search for "./SQLCommand" or simply "SQLCommand ".

Jerry

"Claire Reed" <cl*********@ya hoo.co.uk> wrote in message
news:c6******** *************** **@posting.goog le.com...

Dear All,

I am repeatedly encountering a problem whilst looping through XML
Nodes and I am unsure as to what is going on and how I can get around
it.

I load the following XML document into an XmlDocument object using
LoadXml:

<?xml version="1.0" encoding="UTF-8"?>
<Templates>
<Template Filename="NON.R TN.FORMA3.xml">
<SQLCommand>SEL ECT Addresses.Addre ss_Line1, Addresses.Addre ss_Line2,
Addresses.Addre ss_Line3, Addresses.Addre ss_Line4, FROM
Addresses</SQLCommand>
</Template>
<Template Filename="ERChi ld.NON.RTN.xml" >
<SQLCommand>SEL ECT Addresses.Addre ss_Line1, Addresses.Addre ss_Line2,
Addresses.Addre ss_Line3, Addresses.Addre ss_Line4, Addresses.Postc ode
FROM Addresses</SQLCommand>
</Template>
</Templates>

XmlDocument xdTemplateInfo = new XmlDocument();
xdTemplateInfo. LoadXml(strJobX ml);

(strJobXml contains the Xml as above). I then would like to retrieve
the SQLCommand for a Template whose filename attribute is the same as
my search string (strSearchFile) . I thought that I could do this as
follows:

XmlNodeList xlTemplates =
xdTemplateData. SelectNodes("Te mplates/Template");
foreach (XmlNode xnTemplate in xlTemplates)
{
if (xnTemplate.Att ributes.GetName dItem("Filename ").InnerTex t ==
strSearchFile)
{
//retrieve the SQL
//TODO: the following statement appears to always return the first
//matching node of the document!
XmlNode xnSql =
xnTemplate.Sele ctSingleNode("/Templates/Template/SQLCommand");
strSQLCommand.A ppend(xnSql.Inn erText);
break;
}
}

However, even though xnTemplate refers to a SingleNode in xlTemplates
(the list of Template nodes) the SelectSingleNod e operation always
returns the first matching SQLCommand element in the XmlDocument i.e.
the SQL Command for the template with filename NON.RTN.FORMA3. xml. I
would like to know why the SelectSingleNod e does not apply to the
current node but the whole document and, is there a way to select a
sub-node of a current node?

many thanks

Claire

[Claire Reed]

Thanks Jerry, that worked. I always have problems knowing what the
correct XPath statement should be so thanks for pointing me in the
right direction.

cheers

Claire

"Jerry Pisk" <je******@hotma il.com> wrote in message news:<eT******* *******@TK2MSFT NGP10.phx.gbl>. ..

Because your XPath expression starts with /, which takes the context all the
way to the root node and runs the selection from that context. If you want
to select SQLCommand node that's a child of xnTemplate then you need to
search for "./SQLCommand" or simply "SQLCommand ".

Jerry

"Claire Reed" <cl*********@ya hoo.co.uk> wrote in message
news:c6******** *************** **@posting.goog le.com...

Dear All,

I am repeatedly encountering a problem whilst looping through XML
Nodes and I am unsure as to what is going on and how I can get around
it.

I load the following XML document into an XmlDocument object using
LoadXml:

<?xml version="1.0" encoding="UTF-8"?>
<Templates>
<Template Filename="NON.R TN.FORMA3.xml">
<SQLCommand>SEL ECT Addresses.Addre ss_Line1, Addresses.Addre ss_Line2,
Addresses.Addre ss_Line3, Addresses.Addre ss_Line4, FROM
Addresses</SQLCommand>
</Template>
<Template Filename="ERChi ld.NON.RTN.xml" >
<SQLCommand>SEL ECT Addresses.Addre ss_Line1, Addresses.Addre ss_Line2,
Addresses.Addre ss_Line3, Addresses.Addre ss_Line4, Addresses.Postc ode
FROM Addresses</SQLCommand>
</Template>
</Templates>

XmlDocument xdTemplateInfo = new XmlDocument();
xdTemplateInfo. LoadXml(strJobX ml);

(strJobXml contains the Xml as above). I then would like to retrieve
the SQLCommand for a Template whose filename attribute is the same as
my search string (strSearchFile) . I thought that I could do this as
follows:

XmlNodeList xlTemplates =
xdTemplateData. SelectNodes("Te mplates/Template");
foreach (XmlNode xnTemplate in xlTemplates)
{
if (xnTemplate.Att ributes.GetName dItem("Filename ").InnerTex t ==
strSearchFile)
{
//retrieve the SQL
//TODO: the following statement appears to always return the first
//matching node of the document!
XmlNode xnSql =
xnTemplate.Sele ctSingleNode("/Templates/Template/SQLCommand");
strSQLCommand.A ppend(xnSql.Inn erText);
break;
}
}

However, even though xnTemplate refers to a SingleNode in xlTemplates
(the list of Template nodes) the SelectSingleNod e operation always
returns the first matching SQLCommand element in the XmlDocument i.e.
the SQL Command for the template with filename NON.RTN.FORMA3. xml. I
would like to know why the SelectSingleNod e does not apply to the
current node but the whole document and, is there a way to select a
sub-node of a current node?

many thanks

Claire