XML Related

[nadz]

Hey guys,
Problem stated as:
I have an XML doc
I know how to access the nodes and get the values e.g.
by doing so I get the values for all title nodes.

XmlDocument* doc = new XmlDocument();
doc->Load("c:\\abc.xml");
XPathNavigator* nav = doc->CreateNavigator();
nav->MoveToRoot();
XPathNodeIterator* PixNode = nav->Select("/MetaInfo/File/Title");
while (PixNode->MoveNext())
{
String* num = PixNode->Current->get_Value();
System::Windows::Forms::MessageBox::Show(num);
}

by doing this I get all the values of file nodes

XmlDocument* doc = new XmlDocument();
doc->Load("c:\\abc.xml");
XPathNavigator* nav = doc->CreateNavigator();
nav->MoveToRoot();
XPathNodeIterator* PixNode = nav->Select("/MetaInfo/File");
while (PixNode->MoveNext())
{
String* num = PixNode->Current->get_Value();
System::Windows::Forms::MessageBox::Show(num);
}

but what I want is that I can get a particular files title value.
the sql query would be

select title from first
where filename = "xyz";

help me if anyone has idea plz.

Or it can't be done without transforming XML to sqlType
Thanking you
nadz

[cilu]

Try this:

XPathNodeIterator* PixNode = nav->Select("/MetaInfo/File/[Title='xyz']");

Do you want an exact match or a partial match (such as with the LIKE clause)?

[cilu]

BTW, here is a good introductory tutorial on XPath (http://www.w3schools.com/xpath/).

[nadz]

Thanks cilu
that helped
cheers