• 0

Parse XML with LINQ not reading values


Question

Hi, we're in the process of rewriting one of our webapps to .NET 4.5 and we are trying to use LINQ to parse our XML for outputting. I have the following XML and C# below, but it writes out nothing, I have a feeling it maybe something simple I've overlooked in the code, any help/guidance on LINQ would be appreciated.
 

XML

<?xml version="1.0" encoding="utf-8"?>
<Items>
  <Status>OK</Status>
  <ListOf>
    <Item>
      <Name>Test 1</Name>
      <Description>Test of a really long description</Description>
      <Picture>http://test.com/test.jpg</Picture>
      <Price>Free</Price>
    </Item>
    <Item>
      <Name>Test 2</Name>
      <Description>Test of a really long description</Description>
      <Picture>http://test.com/test2.jpg</Picture>
      <Price>Free under 5s</Price>
    </Item>
  </ListOf>	
</Items>

C#

System.Collections.Specialized.NameValueCollection _query = new System.Collections.Specialized.NameValueCollection() {
{"mode", "test"}
};

using (var wclient = new WebClient())
{
	var result = wclient.UploadValues("http://{XML_ADDRESS_REMOVED}", _query);
	string xml = System.Text.Encoding.UTF8.GetString(result);

	XDocument doc = XDocument.Parse(xml);
	var data = from item in doc.Descendants("Item")
			   select new
			   {
				   Name = item.Element("Name").Value.ToString(),
			   };

	foreach (var item in data)
	{
		Response.Write("Title: " + item.Name + "<br />");
	}
}

2 answers to this question

Recommended Posts

  • 0

I tested the "LINQ" part of the code and it works fine using the provided example XML data. Step into the code and make sure you're getting the correct response from the server.

 

Code used to test:

private void button1_Click(object sender, EventArgs e)
        {
            XDocument doc = XDocument.Parse(File.ReadAllText("data.xml"));
 
            var data = from item in doc.Descendants("Item")
                        select new
                        {
                            Name = item.Element("Name").Value.ToString(),
                        };
 
            foreach (var item in data)
            {
                listBox1.Items.Add("Title: " + item.Name + "<br />");
            }
        }

Output in listBox1:

Title: Test 1<br />
Title: Test 2<br />
This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Posts

    • F'ing FIIINALLY! Much easier to ask people what their hardware is 🙏 and could also very well just say DDR4 or DDR5 without asking to bloat it too much. I'm also curious to see what it will say in More device info...
    • Sure, that must be why it was revealed at the Sony showcase... the game was announced 5 years ago and the visuals are far from poor, what the hell are you smoking, plus the Switch 2 is pretty much on par with an Xbox Series S. It would be absolutely insane for a dev to build a game "with the Switch 2 in mind" when it's coming to all platforms where the majority of sales will happen.
    • The Irony... China wouldn't be what it is today without Apple 😂
    • Microsoft makes it easier to find PC specs in Windows 11 Settings by Taras Buria Windows 11 has already received several improvements that make it easier to learn about your computer's specifications. Recently, Microsoft released Spec Cards for the System > About section, which provide basic information about the PC's main components, such as processor, memory, storage, graphics card, and video memory. Now, the Settings app is getting a new way to find your device info. Microsoft wants to display basic device information right on the Home page of the Settings app. The latest preview builds from the Dev and Beta Channels introduced a new "Your device info" card for the Settings' Home page. It displays specs like processor name and speed, graphics card and the amount of video memory, storage, and RAM. The card also has a link to the "About" section, where you will find more information about your computer, its Windows edition, product ID, and the recently introduced FAQ section that answers common hardware-related questions. The "Your device info" card joins the existing cards on the Settings app's home page. While the section offers useful information like quick access to Bluetooth devices, Wi-Fi, personalization, and recommended settings, users received it with mixed reactions, as many considered it another way for Microsoft to promote its services and subscriptions like Microsoft 365, OneDrive, and Game Pass (seriously, who thinks about Game Pass when opening Settings?). Now, the Settings' Home page is a bit more useful, as it saves you a few clicks when checking your computer's specs. If you want to test the new "Your device info" card, update your PC to build 26200.5622 or newer (Dev Channel). Just keep in mind that Microsoft is rolling it out gradually, and it requires signing in with a Microsoft Account in the United States. Other changes in build 26200.5622 include a new Settings section for Quick Machine Recovery, widget improvements, more app recommendations in the "Open with" dialog, and more. Check out the full release notes here.
  • Recent Achievements

    • Week One Done
      jbatch earned a badge
      Week One Done
    • First Post
      Yianis earned a badge
      First Post
    • Rookie
      GTRoberts went up a rank
      Rookie
    • First Post
      James courage Tabla earned a badge
      First Post
    • Reacting Well
      James courage Tabla earned a badge
      Reacting Well
  • Popular Contributors

    1. 1
      +primortal
      397
    2. 2
      +FloatingFatMan
      178
    3. 3
      snowy owl
      170
    4. 4
      ATLien_0
      167
    5. 5
      Xenon
      134
  • Tell a friend

    Love Neowin? Tell a friend!