如何通过asp.net中的datatable.writexml插入xml文件 [英] How to insert into xml file through datatable.writexml in asp.net

问题描述

这是xml文件的结构

This is the structure of xml File

<?xml version="1.0" encoding="utf-8" ?>
<users>
   <user id="JCollins">
     <fullname>Jim Collins</fullname>
     <deppath>\\JCollinslt02\c$</deppath>
   </user>
<users>

我想插入一个新用户
我该怎么办 userid 的插入方式感到困惑

请帮助

谢谢和问候.
suhailnoorpawane

I want to insert a new user
How can i do that i am confused in the way the userid is inserted

Please Help

Thanks and regards.
suhailnoorpawane

推荐答案

< /deppath > < /user > < 用户 >

</deppath> </user> <users>

我想插入一个新用户
我该怎么办 userid 的插入方式感到困惑

请帮助

谢谢和问候.
suhailnoorpawane

I want to insert a new user
How can i do that i am confused in the way the userid is inserted

Please Help

Thanks and regards.
suhailnoorpawane

private XmlDocument DataTableToXmlDocument(ref DataTable dt)
<pre>{
  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;
}

这篇关于如何通过asp.net中的datatable.writexml插入xml文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！