private string ConvertDataTableToXML(DataTable xmlDS)
{
MemoryStream stream = null;
XmlTextWriter writer = null;
try
{
stream = new MemoryStream();
writer = new XmlTextWriter(stream, Encoding.UTF8);
xmlDS.WriteXml(writer);
int count = (int)stream.Length;
byte[] arr = new byte[count];
stream.Seek(0, SeekOrigin.Begin);
stream.Read(arr, 0, count);
UTF8Encoding utf = new UTF8Encoding();
return utf.GetString(arr).Trim();
}
catch
{
return String.Empty;
}
finally
{
if (writer != null) writer.Close();
}
}
方法使用后 使用后生成的 xml 為
?<NewDataSet><Table><ERP_RECEIVE_ID>761</ERP_RECEIVE_ID><QUANTITY>-10</QUANTITY><BATCH_NO>18113002</BATCH_NO><VALID_DATE>2020-11-29T00:00:00+08:00</VALID_DATE><ORG_ID>DATA10000000000000906285</ORG_ID><PROOF_ID>27955218</PROOF_ID><PROOF_DATE>2020-04-23T00:00:00+08:00</PROOF_DATE><GOODS_AMOUNT>-333.7</GOODS_AMOUNT><UP_PATITION>2004</UP_PATITION></Table><Table><ERP_RECEIVE_ID>762</ERP_RECEIVE_ID><ORDER_ITEM_ID>30ZDAT00000000000073352596</ORDER_ITEM_ID><QUANTITY>-600</QUANTITY><BATCH_NO>3E189K</BATCH_NO><VALID_DATE>2021-06-24T00:00:00+08:00</VALID_DATE><ORG_ID>DATA10000000000000906285</ORG_ID><PROOF_ID>27957152</PROOF_ID><PROOF_DATE>2020-04-29T00:00:00+08:00</PROOF_DATE><GOODS_AMOUNT>-13170</GOODS_AMOUNT><UP_PATITION>2004</UP_PATITION></Table><Table><ERP_RECEIVE_ID>763</ERP_RECEIVE_ID><QUANTITY>-2</QUANTITY><BATCH_NO>LB043851B</BATCH_NO><VALID_DATE>2020-09-30T00:00:00+08:00</VALID_DATE><ORG_ID>DATA10000000000000906285</ORG_ID><PROOF_ID>27957437</PROOF_ID><PROOF_DATE>2020-04-30T00:00:00+08:00</PROOF_DATE><GOODS_AMOUNT>-848</GOODS_AMOUNT><UP_PATITION>2004</UP_PATITION></Table></NewDataSet>
為什么 沒有
<?xml version="1.0" encoding="utf-8" standalone="yes"?>頭
uj5u.com熱心網友回復：
我想的格式是<?xml version="1.0" encoding="utf-8" standalone="yes"?><Table> <Column><欄位></欄位></Column</Table>而我 轉換成了<NewDataSet><Table> </Table><欄位></欄位><Table> </Table></NewDataSet>
轉載請註明出處，本文鏈接：https://www.uj5u.com/qianduan/50270.html
標籤：XML/XSL
上一篇：VBS SENDKEYS無效