Extract values from string containing xml data

Question

Hi..

my string Contains data in xml formatt
For example:

<relatedCategory>
<count>351</count>
<name>Computer-Wholesale & Manufacturers</name>
</relatedCategory>

<relatedCategory>
<count>278</count>
<name>Computer Software & Services</name>
</relatedCategory>

<relatedCategory>
<count>271</count>
<name>Computer Software Publishers & Developers</name>
</relatedCategory>

i want to extract values from this like

351
Computer-Wholesale & Manufacturers

i tried some code but it is not getting those values.it is showing just count,name.

Thanks in advance...

Vulpes · Answer

You have two problems there : 1. Your XML string lacks a root element. 2. The XML string contains ampersands which need to be escaped. Try this LINQ to XML code which deals with these problems: using System; using System.Linq; using System.Xml.Linq; class Test { static void Main() { string xml = " 
"; xml += @" 351 Computer-Wholesale & Manufacturers 278 Computer Software & Services 271 Computer Software Publishers & Developers "; xml += "
 "; // replace ampersands with & xml = xml.Replace("&", "&"); XElement root = XElement.Parse(xml); var rcs = from rc in root.Elements("relatedCategory") select rc; foreach(var rc in rcs) { int count = (int)rc.Element("count"); string name = (string)rc.Element("name"); Console.WriteLine("Count = {0}, Name = {1}", count, name); } Console.ReadKey(); } }