XML String to Object in C#

Question

Hi all I need help in converting XML String to C# Object and vice-versa. My requirement is - The table I am using is as follows - ID Date XML Data Company Location 1 1/2/2012 A F 2 2/2/2012 B E 3 3/2/2012 C D The XML Data is a long string with all the columns - ID Date Company and Location. Now I want to convert this XML String to C# Object. Also I need a function to convert the object to XML String. i.e. Serialization and Deserialization. I don't have any specific class to convert XML to Object. I am getting these records from sql to dataset. Please help me out. Thanks a lot in advance...

Vulpes · Answer

As I'm not completely clear what you want see if you can sort something out from the following code: using System; using System.Data; using System.Xml.Serialization; using System.IO; using System.Text; public class Record { public int ID {get;set;} public string Date {get;set;} public string Company {get;set;} public string Location {get;set;} public override string ToString() { return String.Format(ID = {0} Date = {1} Company = {2} Location = {3} ID Date Company Location); } } class Program { static void Main() { // reproduce data table DataTable dt = new DataTable(); dt.Columns.Add(ID typeof(int)); dt.Columns.Add(Date); // assume this is a string dt.Columns.Add(XML Data); dt.Columns.Add(Company); dt.Columns.Add(Location); string xmlData =  ; dt.Rows.Add(11/2/2012 xmlData A F); dt.Rows.Add(22/2/2012 xmlData B E); dt.Rows.Add(33/2/2012 xmlData C D); // create Record objects and serialize them to Xml strings XmlSerializer xs = new XmlSerializer(typeof(Record)); foreach(DataRow dr in dt.Rows) { Record r = new Record(); r.ID = (int)dr[0]; r.Date = dr[1].ToString(); r.Company = dr[3].ToString(); r.Location = dr[4].ToString(); using (MemoryStream ms = new MemoryStream()) { xs.Serialize(ms r); string xml = Encoding.UTF8.GetString(ms.ToArray()); dr[2] = xml; Console.WriteLine(xml); Console.WriteLine(); } } // now deserialize strings in datatable to Record objects foreach(DataRow dr in dt.Rows) { string xml = dr[2].ToString(); byte[] bytes = Encoding.UTF8.GetBytes(xml); using (MemoryStream ms = new MemoryStream(bytes)) { Record r = (Record)xs.Deserialize(ms); Console.WriteLine(r); } } Console.ReadKey(); } } The output is: g/2001/XMLSchema-instance> 1 1/2/2012 A F g/2001/XMLSchema-instance> 2 2/2/2012 B E g/2001/XMLSchema-instance> 3 3/2/2012 C D ID = 1 Date = 1/2/2012 Company = A Location = F ID = 2 Date = 2/2/2012 Company = B Location = E ID = 3 Date = 3/2/2012 Company = C Location = D

ID	Date	XML Data	Company	Location
1	1/2/2012	<?xml version="1.0"?>	A	F
2	2/2/2012	<?xml version="1.0"?>	B	E
3	3/2/2012	<?xml version="1.0"?>	C	D