Filter XML using XPath

[Felicity]

Hello,

The following XML file shows an example of some config
data for a Side Button Bar control. There are two forms
this Button Bar control relates to, "frmMainMenu"
and "Listing".

<?xml version="1.0" standalone="yes" ?>
- <productx>
- <Table Name="Group1">
<value>ABCDEG</value>
<Parent>MainMenuButtonBar</Parent>
<Menu>NO</Menu>
<Form Name="frmMainMenu" />
</Table>
- <Table Name="Group1">
<value>ABCDEFG</value>
<Parent>MainMenuButtonBar</Parent>
<Menu>NO</Menu>
<Form Name="Listing" />
</Table>
</productx>

Using the following line of code I filter to these two
nodes.

Dim xmlLabelconfigNI as XPathNodeIterator
Dim xmlButtonBarLabelConfigNav as XPathNavigator

xmlLabelconfigNI = xmlButtonBarLabelConfigNav.Select
("/productx/Table[@Name='Group1']" )

I want to know what XPath to use to navigate directly to
the node with Form Name = "frmMainMenu" and Table Name
= 'Group1'. I am VERY unfamilar with XML and have had
some trouble finding valuable help on filtering XML using
XPath.

THanks in advance,

Felicity

Thanks in

[Neetu Rajpal]

The XPath you are looking for is the following:

/productx/Table[Name=='"Group1='" and ./Form/@Name = 'frmMainMenu']

Neetu

[Felicity]

Thanks !!

Using the XPath as below has solved the problem !!

/productx/Table[@Name'Group1' and ./Form/@Name
= 'frmMainMenu']

Once I have successfully found the correct node, how can I
get the value of any of the elements value, parent or Menu?

I have tried using .GetAttribute and .MoveTo on
xmlLabelconfigNI.Current.

Thanks in advance,

Felicity

<?xml version="1.0" standalone="yes" ?>
- <productx>
- <Table Name="Group1">
<value>ABCDEG</value>
<Parent>MainMenuButtonBar</Parent>
<Menu>NO</Menu>
<Form Name="frmMainMenu" />
</Table>
- <Table Name="Group1">
<value>ABCDEFG</value>
<Parent>MainMenuButtonBar</Parent>
<Menu>NO</Menu>
<Form Name="Listing" />
</Table>
</productx>

/productx/Table[Name=='"Group1='" and ./Form/@Name
= 'frmMainMenu']