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(); } }