ToXml
Converts entire DataTabel To XDocument
Source
public static XDocument ToXml(this DataTable dt, string rootName)
{
var xdoc = new XDocument
{
Declaration = new XDeclaration("1.0", "utf-8", "")
};
xdoc.Add(new XElement(rootName));
foreach (DataRow row in dt.Rows)
{
var element = new XElement(dt.TableName);
foreach (DataColumn col in dt.Columns)
{
element.Add(new XElement(col.ColumnName, row[col].ToString().Trim(' ')));
}
if (xdoc.Root != null) xdoc.Root.Add(element);
}
return xdoc;
}
Example
dtCert.ToXml("Certs")
Author: Meysam Javadi
Submitted on: 31 okt. 2012
Language: C#
Type: System.Data.DataTable
Views: 8528