ToXml

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")

Description

Converts entire DataTabel To XDocument

Details

Double click on the code to select all.

 

;