CSV到XML转换器 [英] CSV to XML converter

问题描述

*我一直在研究CSVexporter，但一直陷入某些困境*



**我有什么想法可以解决这个问题？这段代码似乎有错误（见链接）*

[在此处输入图片说明] [1]





[1]：https：//i.stack.imgur.com/L4kZE.png



我尝试过：



我尝试重新连接到数据库，但效果不好

解决方案

< blockquote>

 XmlTextWriter writer = new XmlTextWriter（visitors.xml，Encoding.UTF8）; 
 
 writer.WriteStartDocument（）; 
 writer.WriteStartElement（visitor）; 
 
使用（CsvReader reader = new CsvReader（visitors.csv））
 {
 reader.ReadHeaders（）; 
 
 while（reader.ReadRecord（））
 {
 writer.WriteStartElement（visitor）; 
 
 writer.WriteElementString（visitor_id，reader [visitor_id]）; 
 writer.WriteElementString（first_name，reader [first_name]）; 
 writer.WriteElementString（last_name，reader [last_name]）; 
 
 writer.WriteEndElement（）; 
} 
 
 reader.Close（）; 
} 
 
 writer.WriteEndElement（）; 
 writer.WriteEndDocument（）; 
 writer.Close（）;< pre>< pre lang =c＃> 

*I've been working on a CSVexporter but keep getting stuck at certain points*

**Any ideas how I could solve this problem ? it seems is has an error in here piece of code ( see link )*
[enter image description here][1]


[1]: https://i.stack.imgur.com/L4kZE.png

What I have tried:

I've tried reconnecting to the database but didn't work out well

解决方案

XmlTextWriter writer = new XmlTextWriter("visitors.xml", Encoding.UTF8);

writer.WriteStartDocument();
writer.WriteStartElement("visitors");

using (CsvReader reader = new CsvReader("visitors.csv"))
{
	reader.ReadHeaders();

	while (reader.ReadRecord())
	{
		writer.WriteStartElement("visitor");

		writer.WriteElementString("visitor_id", reader["visitor_id"]);
		writer.WriteElementString("first_name", reader["first_name"]);
		writer.WriteElementString("last_name", reader["last_name"]);

		writer.WriteEndElement();
	}

	reader.Close();
}

writer.WriteEndElement();
writer.WriteEndDocument();
writer.Close();<pre><pre lang="c#">

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