2019獨角獸企業重金招聘Python工程師標準>>>

下面我將用ASP.NET把DataTable的數據轉成XML格式，并輸出生成XML文件。
?
數據庫表position有三個字段：
?
字段名???????????? 字段類型
position_id???????? int
position_name?? varchar
position_desc???? varchar
?
下面是Datatable轉XML的生成源碼：
?

C# Code [http://www.xueit.com]
?
??????? protected void Page_Load(object sender, EventArgs e)
??????? {
??????????? //通過數據訪問層把position讀取到Datatable
??????????? BizRules.PersonnelDAL pl = new PersonnelDAL();
??????????? DataTable dt = pl.Getposition();
??????????? StringBuilder str = new StringBuilder();
??????????? str.Append(DataTableToXml(dt));
??????????? this.CreateXml(str.ToString(), "test.xml");
??????????? Response.Write("生成test.xml成功");
??????? }

??????? /// <summary>
??????? /// 生成文件
??????? /// </summary>
??????? /// <param name="val"></param>
??????? /// <param name="filename"></param>
??????? public void CreateXml(string val, string filename)
??????? {
??????????? UnicodeEncoding ucode = new UnicodeEncoding();
??????????? StreamWriter sw = new StreamWriter(Server.MapPath(filename));
??????????? sw.WriteLine("<?xml version=\"1.0\" encoding=\"utf-8\"?>");
??????????? sw.WriteLine(val);
??????????? sw.Close();
??????????? sw.Dispose();
??????? }

??????? /// <summary>
??????? /// 轉換成XML格式字符串
??????? /// </summary>
??????? /// <param name="dt"></param>
??????? /// <returns></returns>
??????? public string DataTableToXml(DataTable dt)
??????? {
??????????? StringBuilder strXml = new StringBuilder();
??????????? strXml.AppendLine("<XmlTable>");
??????????? for (int i = 0; i < dt.Rows.Count; i? )
??????????? {
??????????????? strXml.AppendLine("??? <rows>");
??????????????? for (int j = 0; j < dt.Columns.Count; j? )
??????????????? {
??????????????????? strXml.AppendLine("??????? <"?? dt.Columns[j].ColumnName?? ">"?? dt.Rows[i][j]?? "</"?? dt.Columns[j].ColumnName?? ">");
??????????????? }
??????????????? strXml.AppendLine("??? </rows>");
??????????? }
??????????? strXml.AppendLine("</XmlTable>");
??????????? return strXml.ToString();
??????? }?
下面看下生成XML文件的效果：
?
<?xml version="1.0" encoding="utf-8"?>
<XmlTable>
?<rows>
? <position_id>29</position_id>
? <position_name>業務員</position_name>
? <position_desc></position_desc>
?</rows>
?<rows>
? <position_id>30</position_id>
? <position_name>業務經理</position_name>
? <position_desc></position_desc>
?</rows>
?<rows>
? <position_id>31</position_id>
? <position_name>業務總監</position_name>
? <position_desc></position_desc>
?</rows>
</XmlTable>

轉載于:https://my.oschina.net/guanxinsui/blog/915232

總結

以上是生活随笔為你收集整理的ASP.NET把DataTable转成XML文件的函数的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。