Retrieving values from XML file

[Mike]

I want to be able access an xml file using an XPath? query to go to a
specific node. Once I have that node I want to be able to retrieve the value
of an attribute. Can't seem to get this working using the 2.0 Framework.
Here's a sample of the XML

<Agency>

<vu_Agency AgencySysNo="1" Name="Dept 1"/>

<vu_Agency AgencySysNo="2" Name="Dept 2"/>

</Agency>
The code I'm playing with is...

Dim document As XPathDocument = New
XPathDocument(C onfigurationMan ager.AppSetting s("xmlPath").To String() &
"Agency.xml ")

Dim navigator As XPathNavigator = document.Create Navigator()

Dim agencySysNo As Integer = 2

Dim exp As XPathExpression =
navigator.Compi le("/Agency/vu_Agency[@AgencySysNo=" & agencySysNo & "]")

Dim nodes As XPathNodeIterat or

nodes = navigator.Selec t(exp)

Dim nodesNavigator As XPathNavigator = nodes.Current

Dim nodesText As XPathNodeIterat or =
nodesNavigator. SelectDescendan ts(XPathNodeTyp e.Text, True)

Response.Write( nodesText.Curre nt.Value)

Thanks for any help....

--
Mike Gasperino
Sr. Software Developer
office: 919-807-2310

*************** *************** *************** *************** *************** *
E-mail correspondence to and from this address may be subject to the North
Carolina Public Records Law "NCGS.Ch.13 2" and may be disclosed to third
parties
*************** *************** *************** *************** *************** *

[Pascal Schmitt]

Hello!

Try this (it is C#, I'm not sure of the VB syntax :o)

....
XPathExpression exp =
navigator.Compi le(string.Forma t("/Agency/vu_Agency[@AgencySysNo='{ 0}']/@Dept",
agencySysNo ));

XmlNode n = navigator.Selec tSingleNode( exp )
if( n != null )
Response.Write( ((XmlAttribute) n).Value );
The XPath Expression directly selects the Attribute (I suppose it is
unique?) and returns null/Nothing if it wasn't found. If it retourned
something, it is the Attribute, so I cast it as an XmlAttribute and
return its Value.
--
Pascal Schmitt

[Mike]

Hey Pascal,

I get a pre-compile message on this line of code "XmlNode n =
navigator.Selec tSingleNode( exp )"

Value of type 'System.Xml.XPa th.XPathNavigat or' cannot be converted to
'System.Xml.Xml Node'.

How do I convert to a xmlnode?

Thanks
"Pascal Schmitt" <ne*******@cebr a.nu> wrote in message
news:OZ******** ******@TK2MSFTN GP14.phx.gbl...

Hello!

Try this (it is C#, I'm not sure of the VB syntax :o)

...
XPathExpression exp =
navigator.Compi le(string.Forma t("/Agency/vu_Agency[@AgencySysNo='{ 0}']/@Dept",
agencySysNo ));

XmlNode n = navigator.Selec tSingleNode( exp )
if( n != null )
Response.Write( ((XmlAttribute) n).Value );
The XPath Expression directly selects the Attribute (I suppose it is
unique?) and returns null/Nothing if it wasn't found. If it retourned
something, it is the Attribute, so I cast it as an XmlAttribute and return
its Value.
--
Pascal Schmitt

[Martin Honnen]

Mike wrote:

I get a pre-compile message on this line of code "XmlNode n =
navigator.Selec tSingleNode( exp )"

Value of type 'System.Xml.XPa th.XPathNavigat or' cannot be converted to
'System.Xml.Xml Node'.

If you have an XPathNavigator then there is (at least in .NET 1.x) no
SelectSingleNod e method, there is a Select method however so you are
likely looking for something as

XPathNodeIterat or iterator = navigator.Selec t(exp);
while (iterator.MoveM ext()) {
// access iterator.Curren t here
}
--

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