Thread: SelectNodes (Extracting data XML File)

Hi,

I using SelectNodes to extract data from an xml file.
Using the code below I can extract the data i.e. the prices for a particular category:

XmlDocument *doc = new XmlDocument();

XmlNodeList *prodNodes;

prodNodes = doc->SelectNodes("/PRODUCTS/FRUIT[CATEGORY= 'Orange' ]/PRICE");

However, when I try using a variable with SelectNodes it does not seem to work, therefore what is the correct syntax to use (C++).

i.e.

String * selectedItem = FoodCategoryLstBox->SelectedItem.ToString();


messageNodes = prodNodes->SelectNodes("/PRODUCTS / FRUIT [CATEGORY = ‘selectedItem' ]/PRICE");

Thanks for your help!

What is SelectNodes?

This might work.

Code:

String * selectedItem = FoodCategoryLstBox->SelectedItem.ToString();

String * query = String::Format(S"/PRODUCTS / FRUIT [CATEGORY = ‘{0}' ]/PRICE", selectedItem);

messageNodes = prodNodes->SelectNodes(query);

Hi anonytmouse,

Thanks for your help, unfortunately I couldn’t get it to work , However, I have now used the following which works:

XmlDocument *doc = new XmlDocument();

XmlNodeList *prodNodes;

String * selectedItem = FoodCategoryLstBox->SelectedItem.ToString();

String *query = query ->Concat("/PRODUCTS /FRUIT [CATEGORY ='", selectedItem, "']/PRICE");

prodNodes = doc ->SelectNodes(query);



However, I use SelectNodes elsewhere in my program see below:
….

String * selectedItem = FoodCategoryLstBox->SelectedItem.ToString();

String *Item= ItemcmbBox->SelectedItem->ToString();

String * query = query ->Concat("/PRODUCTS / FRUIT [CATEGORY ='", selectedItem, "' and ITEM= '", Item, "']/PRICE ");

Although I cant seem to get this to work using Concat.

I tried it using C# and I can get it working using the following syntax:

doc.SelectNodes("/PRODUCTS/FRUIT [CATEGORY= '" + FoodCategoryLstBox.SelectedItem.ToString() + "' and ITEM = '" + ItemcmbBox.SelectedItem.ToString() + "']/ PRICE ");

But I can’t get working under C++.

Would anyone know what I’m doing wrong?

Thanks in advance!

Vart String is part of .NET as I'm using WindowsForms

error C2958: the left parenthesis '(' found at ....... was not matched correctly

thats the error it gives me when using your code

thanks for your help anyway vart

Vart I tried but it gives me the following error:
error C2665: 'System::String::Concat' : none of the 9 overloads can convert parameter 1 from type 'const char [30]'

It's pretty frustrating as I know what I want it to do will work but can’t seem to get the right syntax for the string.

Hi Vart thanks for all your help, sorry to be a bother could you just show me what I need to write in the Concat string section please?

Thanks in advance for your help!