我们将一个有数据的DataTable新增加一列Name,并赋值
public string GetXml()
{
DataTable data = new DataTable();
data=GetData();
//增加列
data.Columns.Add("Name", typeof(string));
//要加上这行代码,否则新增加的列Name在转换后格式不是我们想要的
data.Columns["Name"].ColumnMapping = MappingType.Attribute;
//赋值
foreach (DataRow row in data.Rows)
{
row["Name"]="test";
}
string xml=ConvertDataTableToXML(data);
return xml;
}
//将datatable转换xml
public string ConvertDataTableToXML(DataTable dt)
{
MemoryStream stream = null;
XmlTextWriter writer = null;
try
{
DataSet ds = new DataSet("List");
ds.Tables.Add(dt.Copy());
stream = new MemoryStream();
writer = new XmlTextWriter(stream, Encoding.Unicode);
ds.WriteXml(writer);
int count = (int)stream.Length;
byte[] arr = new byte[count];
stream.Seek(0, SeekOrigin.Begin);
stream.Read(arr, 0, count);
UnicodeEncoding utf = new UnicodeEncoding();
string Header = "<?xml version=\"1.0\"?>" + "\r\n" +
"<ListConfig xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\">";
string Text = System.Text.Encoding.Unicode.GetString(arr, 2, count - 2);
return String.Format("{0}\r\n{1}\r\n{2}", Header, Text, "</FreqBandConfig>"); ;
}
catch (System.Exception ex)
{
throw ex;
}
finally
{
if (writer != null)
writer.Close();
}
}