Xml parsing in a specific format and then searching and listing all the occurrence of any values

Question

0.00/5 (No votes)

See more:

Hello, my requirement is as follows:
1= read an xml url and then search a specific value using a text box and then list all the occurrence of that text in parsed order

For eg: my API is as follows:

HTML

<blockquote class="FQ"><div class="FQA">Quote:</div>
<Record1>
<ID>4</ID>
<Name>ABCD</Name>
<NumberOfPosition>1</NumberOfPosition>
<Rate>0</Rate>
<SignalID>102288301</SignalID>
<SignalTime>2013-07-16T23:59:59.043</SignalTime>
<SignalType>CloseMarketOrder</SignalType>
<Loss>0</Loss>
<SubName>78730843</SubName>
<SystemID>720</SystemID>
<SystemName>Passion 1</SystemName>
<Profitrate>0</Profitrate>
</Record1>

<pre lang="HTML"><blockquote class="FQ"><div class="FQA">Quote:</div><Record2>
<ID>4</ID>
<Name>ABCD</Name>
<NumberOfPosition>1</NumberOfPosition>
<Rate>0</Rate>
<SignalID>102288301</SignalID>
<SignalTime>2013-07-16T23:59:59.043</SignalTime>
<SignalType>CloseMarketOrder</SignalType>
<Loss>0</Loss>
<SubName>78730843</SubName>
<SystemID>720</SystemID>
<SystemName>Passion 1</SystemName>
<Profitrate>0</Profitrate>
</Record2>
and so on 
</blockquote>

I want to parse it like:
ID = 4
Name = ABCD
etc

and then search using a text box for eg: Name = ABCD so this search should check the all the occurrence of ABCD in the xml and list the complete data in the text box

Plese help

Posted 17-Jul-13 23:15pm

Mitul12

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**Joezer BH** · Answer 1 · 2013-07-17T23:43:00

Solution 1

Here's an example using Linq:

C#

var xmlNodes= from element in XElement.Load("MyXmlFile.xml").XPathSelectElements("/Items/Item/Description")
            select new
            {
                Value = element.Value.Trim()
            };
 
foreach (var node in xmlNodes)
{
    // Do Stuff with "node", E.g.:
    MyListBox.Items.Add(node);
}

* In case you are not familiar with XPath, I'd suggest you give it a few minutes to learn, it's quite handy! See a tutorial here[^].

Good luck,
Edo

Posted 17-Jul-13 23:43pm

Joezer BH

Updated 20-Jul-13 19:26pm

v4

Comments

Mitul12 18-Jul-13 19:35pm

Thanks for the reply, but i asked how to search a string and then print the result of complete data matching that string
For eg: in the above example
if i search for ABCD then it should result all data related to ABCD abd if suppose ABC is occuring many times in the xml then also all the relavent data should be printed in the text box

Please help

Joezer BH 21-Jul-13 1:24am

IF I understand you correctly, then the example should work just fine, you just need to use the XPath from your textbox in the select elements line above:
XElement.Load("MyXmlFile.xml").XPathSelectElements(YourTextboxTextHere);

* If you are not familiar with XPath, I'd suggest you give it a few minutes - it's quite handy!