C# WEB: Convert TXT file to XML

[obiman]

I would like to convert plain txt files into xml. The text is comma separated with the first row containing field headings.

I would like to do this in C# to run in a Web Application.
I'll then display the contents of the newly formed XML file using GridView tool or similar.

I'd appreciate it if anyone can help me out with the txt -> xml conversion in C#

cheers

[Shashi Sadasivan]

I would like to convert plain txt files into xml. The text is comma separated with the first row containing field headings.

I would like to do this in C# to run in a Web Application.
I'll then display the contents of the newly formed XML file using GridView tool or similar.

I'd appreciate it if anyone can help me out with the txt -> xml conversion in C#

cheers

You would have to do this manuallly i suppose.
read all the headers, and create respective nodes for their xml counterpart.

If yyou are unable to do it, send me a mail and i will try it

[Shashi Sadasivan]

hi obiman,
I dont know if you were able to do your task,
i fished for some data exporting stuff of mine and found what you want

string ConnectionString = @"Driver={Microsoft Text Driver (*.txt; *.csv)};DBQ=c:\draw1.txt";
            OdbcConnection conn = new OdbcConnection(ConnectionString);
            conn.Open();
            OdbcDataAdapter da = new OdbcDataAdapter("Select * FROM draw1.txt", conn);
 
 
            DSDrawing.DRAWINGDataTable dt = new DSDrawing.DRAWINGDataTable();
 
            DataSet ds = new DataSet();
 
            da.Fill(ds, "dbo.DRAWING");
            ds.WriteXml(@"C:\outputfile.xml");
            Console.WriteLine("Loaded");
            conn.Close();

Hope this helps and is clear