数据到XML的转换 [英] Conversion of Data to XML

问题描述

使用C#将SQL中的数据库表数据转换为asp.net中的XML文件的代码.

Code to convert data of database tables in SQL to XML file in asp.net using C#.

推荐答案

private XmlDocument DataTableToXmlDocument(ref DataTable dt)
{
  XmlDocument xml= new XmlDocument();
  StringBuilder sb = new StringBuilder();

  sb.Append("<?xml version='1.0' encoding='utf-8' ?>");
  sb.Append("<DocumentElement>");

  foreach (DataRow dr in dt.Rows)
  {
    sb.Append("<" + dt.TableName + ">");

    foreach (DataColumn dc in dt.Columns)
      sb.Append("<" + dc.ColumnName + ">" +
              dr[dc].ToString() +
           "</" + dc.ColumnName + ">");

      sb.Append("</" + dt.TableName + ">");
  }

  sb.Append("</DocumentElement>");
  xml.LoadXml(sb.ToString());

  return xml;
}

或这个

OR this

public

 XmlDocument DataTableToXML(DataTable table)
 
{
 

XmlDocument _XMLDoc = new XmlDocument();
 
_XMLDoc.LoadXml(table.DataSet.GetXml());
 

return _XMLDoc;
 
}

或使用LInq之类的东西

Or Using LInq Something lIKE THIS

XDocument doc = new XDocument(                new XDeclaration("1.0", "UTF-8", "yes"),                new XElement("products",                     from p in dt.AsEnumerable()                    select new XElement("product",                        new XAttribute("guid", p["ProductId"]),                        new XAttribute("title", p["Title"]),                        new XAttribute("version", p["Version"]))));

这篇关于数据到XML的转换的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！