How to process XML data into collection in c#.NET?

Question

Hi In my sql table one of column having XML column which hold data in xml format. I want to fetch that sql table xml column data into c# code stored it into string variable. once i store it into string variable i want to store all xml attribute key and value into Collection. Note--> XML column data available in below format 1 A How i achieve it in c#.net? Please suggest any one approach!

Vulpes · Answer

Something like this perhaps. In practice of course xmlData would be read from the database: using System.Collections.Generic; using System.Xml.Linq; // .... string xmlData = @ 1 A ; XElement customer = XElement.Parse(xmlData); var customerData = new Dictionary (); foreach(XElement element in customer.Elements()) { customerData.Add(element.Name.ToString() element.Value); } // print to a MessageBox string message = ; foreach(string key in customerData.Keys) { message += String.Format({0} : {1}
 key customerData[key]); } MessageBox.Show(message);