Code Snippets

C# Source Code

Welcome to Dream.In.Code
	Become a C# Expert! Join 244,258 C# Programmers for FREE! Get instant access to thousands of C# experts, tutorials, code snippets, and more! There are 1,274 people online right now. Registration is fast and FREE... Join Now! Chat LIVE With a C# Expert

Convert delimited file to XML

This is a small snippet showing how to convert a delimited file to an XML document

Submitted By: PsychoCoder

Actions:

Rating:

Views: 2,431

Language: C#

Last Modified: September 1, 2007

Instructions: This method requires 3 parameters:

delimiter: The delimiter the file is delimited with
file: The name of the file
xmlFileName: name and path of the XML file you wish to create

Snippet

public void ConvertDelimitedToXML(char delimiter, string file,string xmlFileName)
{
//create the objects we need
System.Data.DataSet xmlDataSet = new System.Data.DataSet();
System.Data.DataTable xmlTable = new System.Data.DataTable();
System.Data.DataRow xmlRows;
using (StreamReader reader = new StreamReader(file))
{
//set the DataSetName of the DataSet
xmlDataSet.DataSetName = "YourName";
//set the NameSpace of the DataSet
xmlDataSet.Namespace = "YourNamespace";
//make sure we're at the beginning of the file
reader.BaseStream.Seek(0, SeekOrigin.Begin);
//add the header columns
foreach (string fields in reader.ReadLine().Split(delimiter))
{
//xmlDataSet.Tables(0).Columns.Add(fields);
xmlTable.Columns.Add(fields);
}
//now add the rows
while (reader.Peek() != -1)
{
xmlRows = xmlTable.NewRow();
foreach (string fields in reader.ReadLine().Split(delimiter))
{
xmlTable.Rows.Add(fields);
}
//add the new rows to the table
xmlTable.Rows.Add(xmlRows);
}
//add the table to the DataSet
xmlDataSet.Tables.Add(xmlTable);
//write out the XML
xmlDataSet.WriteXml(xmlFileName);
}
}

Copy & Paste

public void ConvertDelimitedToXML(char delimiter, string file,string xmlFileName)
{
    //create the objects we need
    System.Data.DataSet xmlDataSet = new System.Data.DataSet();
    System.Data.DataTable xmlTable = new System.Data.DataTable();
    System.Data.DataRow xmlRows;

using (StreamReader reader = new StreamReader(file))
    {
        //set the DataSetName of the DataSet
        xmlDataSet.DataSetName = "YourName";
        //set the NameSpace of the DataSet
        xmlDataSet.Namespace = "YourNamespace";

//make sure we're at the beginning of the file
        reader.BaseStream.Seek(0, SeekOrigin.Begin);
        //add the header columns
        foreach (string fields in reader.ReadLine().Split(delimiter))
        {
             //xmlDataSet.Tables(0).Columns.Add(fields);
             xmlTable.Columns.Add(fields);
        }
        //now add the rows
        while (reader.Peek() != -1)
        {
            xmlRows = xmlTable.NewRow();
            foreach (string fields in reader.ReadLine().Split(delimiter))
            {
                 xmlTable.Rows.Add(fields);
            }
            //add the new rows to the table
                    xmlTable.Rows.Add(xmlRows);
        }
        //add the table to the DataSet
        xmlDataSet.Tables.Add(xmlTable);
        //write out the XML
        xmlDataSet.WriteXml(xmlFileName);
    }           
}