XML String to Object in C#

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(1,"1/2/2012", xmlData, "A", "F");

dt.Rows.Add(2,"2/2/2012", xmlData, "B", "E");

dt.Rows.Add(3,"3/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:

1/2/2012

2/2/2012

3/2/2012

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

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Vulpes12y ago
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(1,"1/2/2012", xmlData, "A", "F");
dt.Rows.Add(2,"2/2/2012", xmlData, "B", "E");
dt.Rows.Add(3,"3/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:

1
1/2/2012
A
F

2
2/2/2012
B
E

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		A	F
2	2/2/2012		B	E
3	3/2/2012		C	D