Load / parse XML from a URL web into a XElement

Question

5.00/5 (1 vote)

See more:

Hello ,
I'm new with C# Linq.
I have a code to combine 2 xmls and save it in a merged.xml and worked perfectly when both xml sources were in local folders ("C:\..\..."). Now I'm trying to load the same xml of one data source from a web url and I can't retrieve the xml successfully into g xElement. With xmlTextReader I get the xml from the web and I'm printing it in the console correctly formated but I don't know how to load this xml in my g xElement to still combining sucessfully with the first and local xml doc1.xml .

The main problem it's I don't know how to load/parse the xml data from the web into 'g' xmlElement.

C#

 String URLString = "http://www.XXX.com/XX/XX/getAllPackages";//Source of my xml
 XmlTextReader reader = new XmlTextReader(URLString);
                  
//Code is read and printing xml from the web url.
            while (reader.Read())
            {
            switch (reader.NodeType)
                {
                    case XmlNodeType.Element: // Node is an element.
                        Console.Write("<" + reader.Name);

                        while (reader.MoveToNextAttribute()) // Read Atributtes
                        Console.Write(" " + reader.Name + "='" + reader.Value + "'");
                        Console.WriteLine(">");                        
                        break;
                    case XmlNodeType.Text: //Show text on each element.
                        Console.WriteLine (reader.Value);
                        break;
                    case XmlNodeType. EndElement: //Show the final element
                        Console.Write("</" + reader.Name);
                        Console.WriteLine(">");
                        break;
                }
       
            }

//Code to combine both xmls   
         

var query = (from bl in XElement.Load(@"C:\xx\doc1.xml").Elements("line_item_data").GroupBy(i1 =>
                            i1.Element("line_item").Value).Select(i1 => i1.First())

                         join g in XElement.Load(reader,LoadOptions.PreserveWhitespace).Elements("productVersionDetails").GroupBy(i1 =>
                            i1.Element("product").Value).Select(i1 => i1.First())
                     on (string)bl.Element("line_item").Value equals (string)g.Element("product").Value
              where ((string)g.Element("type")).Equals("MSD")                               

              select new XElement("product_item",

                   new XElement("version_id", (string)g.Element("version_id")),
                   new XElement("technology_process",(string)bl.Element("technology_process")),
                   new XElement("product", (string)g.Element("product")),
                   new XElement("version", (string)g.Element("version")),
                   new XElement("status", (string)g.Element("status")),
                   new XElement("owner_name", (string)bl.Element("owner_name")),
                   new XElement("description", (string)g.Element("description")),
                   new XElement("os", (string)g.Element("os"))

             )).ToList();

            //Save the new full List in the path data source File 
         var doc = new XElement("ArrayOfProductVersionDetails", query);
         doc.Save(@"C:\xxx\xx\XML_Merged.xml");           
         Console.WriteLine("XML merged and file saved.");

Posted 28-Feb-14 1:50am

Kinna-10626331

Updated 28-Feb-14 4:01am

v5

Add a Solution

3 solutions

Solution 1

I'm afraid your XmlTextReader is already at the end of the stream; it got there when you were printing the stuff into console. It's logical that the second attempt to read it using XElement.Load without resetting the reader at the beginning fails. And, BTW, why don't you use XDocument class? In general, an XML document is not only its root element, it may contain some DOCTYPE, etc.

Posted 28-Feb-14 5:40am

Vladimir Svyatski

Comments

Kinna-10626331 3-Mar-14 4:02am

Thanks VUnreal !! I follow your advice , you can check it in my answer.

Solution 2

VUnreal looks right. Try to load the xml with XmlDocument class which will load xml content properly if it has DTD otherwise try using XDocument class to load xml in your code.

Posted 28-Feb-14 11:17am

KmgKrishnan

Comments

Kinna-10626331 3-Mar-14 4:03am

Thanks KmgKrishnan !! I follow your advice also , you can check it in my answer.

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)

Kinna-10626331 · Accepted Answer · 2014-03-02T22:01:00

Solution:

Thanks! At the end I follow the advice of VUnreal and KmgKrishnan, I insert the xml data from the url in a xmlDocument and after I load this xml on a XElement in the join as I was doing before from local paths. It Works :) .

C#

          //Loading in  myXmlDocument the xml  from the url 
            string m_strFilePath = "http://www.XXX.com/XX/XX/getAllPackages";
            XmlDocument myXmlDocument = new XmlDocument();           
            //myXmlDocument.Save(Console.Out); 
            myXmlDocument.Load(m_strFilePath);



var query = (from bl in XElement.Load(@"C:\xx\doc1.xml").Elements("line_item_data").GroupBy(i1 =>
                            i1.Element("line_item").Value).Select(i1 => i1.First())

                         join g in XElement.Load(new XmlNodeReader(myXmlDocument)).Elements("productVersionDetails").GroupBy(i1 =>
                            i1.Element("product").Value).Select(i1 => i1.First())
                     on (string)bl.Element("line_item").Value equals (string)g.Element("product").Value
              where ((string)g.Element("type")).Equals("MSD")

              select new XElement("product_item",

                   new XElement("version_id", (string)g.Element("version_id")),
                   new XElement("technology_process",(string)bl.Element("technology_process")),
                   new XElement("product", (string)g.Element("product")),
                   new XElement("version", (string)g.Element("version")),
                   new XElement("status", (string)g.Element("status")),
                   new XElement("owner_name", (string)bl.Element("owner_name")),
                   new XElement("description", (string)g.Element("description")),
                   new XElement("os", (string)g.Element("os"))

             )).ToList();

            //Save the new full List in the path data source File
         var doc = new XElement("ArrayOfProductVersionDetails", query);
         doc.Save(@"C:\xxx\xx\XML_Merged.xml");
         Console.WriteLine("XML merged and file saved.");