整理从数据表转换而来的XML

本文关键字：XML 转换 数据表 | 更新日期: 2023-09-27 17:51:02

我已经将我的DataTable转换成XML。

当前xml输出如下:

<DocumentElement>'r'n <cardDetails>'r'n  <mid>123456789190</mid>'r'n  <cardnumber>1234</cardnumber>'r'n   <expmonth>01</expmonth>'r'n <expyear>2017</expyear>'r'n   <cvv>404</cvv>'r'n    <amount>3.54</amount>'r'n   <exptime>1/1/2017 11:03:38 AM</exptime>'r'n  <responsecode>0000</responsecode>'r'n </cardDetails>'r'n

我希望我的输出是这样的…

<DocumentElement> 
<cardDetails> 
<mid>123456789190</mid>    
<cardnumber>123456789190</cardnumber>    
<expmonth>01</expmonth>    
<expyear>2017</expyear>   
<cvv>404</cvv>    
<amount>3.54</amount>    
<exptime>1/1/2017 11:03:38 AM</exptime>    
<responsecode>0000</responsecode>  
</cardDetails

这是我的代码

DataTable table = getGenerate.generateCard(mid, passcode, amount, expmonth, expyear, expday, days, hrs, numberOfCards);
            string xmlString = string.Empty;
            using (TextWriter writer = new StringWriter())
            {
                table.WriteXml(writer);
                xml = writer.ToString();
            }
        return xml;

有什么帮助吗?

整理从数据表转换而来的XML

我不确定您的用例，但是您可以这样做来解决您的用例。

xml.Split( new [] {@"'r'n"} , StringSplitOptions.RemoveEmptyEntries)

你可以在这里找到工作代码

相关文章：