How can i retrieve all xml node value and CDATA value into a list using LINQ

Question

0.00/5 (No votes)

See more:

Hello experts, i want to extract the an XML element are their corresponding value in to a List of NameValueCollection like (List<namevaluecollection>), and also retrieve all the CDATA present in the element into the List as well using LINQ to XML code in C#. and also i want to allow user to just enter an Element name in the method below a the method should display its value or its CDATA value. Thanks

Here the XML Data.

XML

<?xml version=\"1.0\" encoding=\"utf-8\" ?>
<TRANS_NET>
<REQUEST_ID>1278999</REQUEST_ID>
<REQUEST_DATE>2013-12-06 12:10:23.0</REQUEST_DATE>

<RESPONSE_CODE>001</RESPONSE_CODE>
<RESPONSE_REASON>
<SUCCESS>100</SUCCESS>
</RESPONSE_REASON>

<CATALOG>
<CARDDATA>
<SERIAL_NO>11177202</SERIAL_NO>
<BATCH_NO>3980</BATCH_NO>
<BASE_CARD_TYPE> <![CDATA[REV </BASE_CARD_TYPE>
<CARD_TYPE><![CDATA[PRDC</CARD_TYPE>
<CARD_NAME><![CDATA[inCharge Global Cards</CARD_NAME>
<CARD_STATUS>A</CARD_STATUS>
<CURRENCY_CODE><![CDATA[GHS</CURRENCY_CODE>
<CURRENT_BALANCE>0.000</CURRENT_BALANCE>
<EXPIRED><![CDATA[N</EXPIRED>
<MAX_CAP>100000000000.000</MAX_CAP>
<EXP_DATE><![CDATA[2016-10</EXP_DATE>
</CARDDATA>
</CATALOG>
</TRANS_NET>

An here is my Lin

Here is my C# Code

public NameValueCollection GenericGetXMLTreeValue(string xmlTag, string toTraverse)
        {
            if (xmlTag == null || xmlTag.Length <= 0)
                throw new ArgumentNullException("Element To Check Can Not Be Empty");
            if (toTraverse == null || toTraverse.Length <= 0)
                throw new ArgumentNullException("XML Response Can Not Be Empty");

            NameValueCollection arrXMLResponse = new NameValueCollection();

            XElement cardData = XElement.Parse(toTraverse);
            foreach (XElement eachXelement in cardData.Descendants())
            {
                arrXMLResponse.Add(eachXelement.Element(xmlTag).Name.LocalName, eachXelement.Element(xmlTag).Value);
            }

            return arrXMLResponse;
        }</namevaluecollection>

Posted 22-Dec-13 5:15am

ahmedfaruk88

Updated 22-Dec-13 5:30am

JoCodes

v3

Add a Solution

2 solutions

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)

JoCodes · Answer 1 · 2013-12-22T05:50:00

Solution 1

Refer

http://stackoverflow.com/questions/16609350/get-nodes-from-xml-using-linq-in-c-sharp[^]

Hope this helps...

Posted 22-Dec-13 5:50am

JoCodes

Sergey Alexandrovich Kryukov · Answer 2 · 2013-12-22T07:15:00

Solution 2

If logical XML structure, there is no such thing as CDATA, this is no more than a way to "escape" all XML formatting characters in some string value, a part of physical XML structure. In other workds, "CDATA" is not a part of the data structure stored in XML, it is yet another artifact of XML formatting. You simply need to get the text node of your XML element BASE_CARD_TYPE.

If you want to use LINQ to XML programming, the most adequate XML parser would be System.Xml.Linq.XDocument, read the MSDN documentation on it: http://msdn.microsoft.com/en-us/library/system.xml.linq.xdocument%28v=vs.110%29.aspx[^].

—SA

Posted 22-Dec-13 7:15am

Sergey Alexandrovich Kryukov

Updated 22-Dec-13 7:16am

v2

Comments

ahmedfaruk88 23-Dec-13 7:54am

Thank you very much. i am surprise how you guys know so much. Thanks to codeproject too. I will check it out and get back to you. Please can i always contact you when i have a challenge.

Sergey Alexandrovich Kryukov 23-Dec-13 12:56pm

You are welcome. Please don't forget to accept the answer formally (green "Accept" button) if you find it makes sense for you, but your follow-up questions will be welcome.
If you want to ask a question and bring it to my attention, you can add a comment to any of my existing posts, like this one. I receive notifications on all comments to my posts and other relevant posts.
—SA