programmatically creating xml from txt file......anyone.......help

Question

Thank you,
I have to create an xml out of the text file.. The text file is
Table Id: Products
ColumnName           Type       Length
------------------------------------------------------------
ProdNo               varchar      8
ProdName             varchar      10
ProductQuantity      nvarchar     10
Table Id: ProductOrder
ColumnName           Type       Length
------------------------------------------------------------
ProductOrder         varchar      8
Prodstatus           varchar      10
I have to create xml format for the above tables...... how do I do that.
Help

Sanjeev Shrestha · Answer

Thank you,
Mr. Mahesh Chand.....but I did not get article to make DataSet out of the txt file.
Can you kindly let me know.. Does it work for the table I posted..
Appreciate your reply.

Mahesh Chand · Answer

You can read txt file in an ADO.NET DataSet and use WriteXml method of DataSet to write contents to the xml file. Search this site for how to read a Txt file in ADO.NET DataSet.
Alternatively, you can read a txt file using TextReader and create a DataSet in memory and add rows from the text reader and write DataSet contents to XML file using WriteXml method. See this article how to read a text file.
http://www.c-sharpcorner.com/Language/CSAndTypesGAG.asp