public void ConvertToXML(string CSVFile, string XMLoutputFile)
{
//Read CSV file
using (CsvReader csvReader = new CsvReader(new StreamReader(CSVFile), true))
{
int fieldCount = csvReader.FieldCount;
//MessageBox.Show("Field count : " + fieldCount.ToString());
//read headers
string[] headers = csvReader.GetFieldHeaders();
XmlWriter writer = XmlWriter.Create(XMLoutputFile);
try
{
using (writer)
{
writer.WriteStartDocument();
writer.WriteStartElement("Root");
//read the rest of the file
while (csvReader.ReadNextRecord())
{
//create data element
writer.WriteStartElement("Data");
//reade each row
for (int i = 0; i < fieldCount; i++)
{
//check the value for illigal XML characters
StringBuilder buffer = new StringBuilder(csvReader[i].Length);
foreach (char c in csvReader[i])
{
if (IsLegalXmlChar(c))
{
buffer.Append(c);
}
}
writer.WriteElementString(headers[i], buffer.ToString());
}
//write end data element
writer.WriteEndElement();
}
//write end root element
writer.WriteEndElement();
//write end document
writer.WriteEndDocument();
}
}
finally
{
if (writer != null)
{
writer.Close();
XmlPrettyPrinter printer = new XmlPrettyPrinter();
printer.PrintXmlFile(XMLoutputFile);
}
}
}
//return csvDoc;
}
