C# CSV to XML Conversion, CSV to XML Conversion using LINQ Read more at http://dotnetdud.blogspot.com/2008/10/c-csv-to-xml-conversion-csv-to-xml.html#Aj2tQrpD5ELjLI8Z.99

How to Convert CSV to XML using C#
Language Integrated Query (LINQ) can be used to convert a CSV file to XML. Here is the sample CSV file that needs to be converted
The following code reads the CSV file to an array. LINQ is used to loop through the array and the contents are written as XML using XElement (System.XML.Linq).

public void ConvertCSVToXML()
{
String[] FileContent = File.ReadAllLines(@"C:\Temp\vba.csv");
String XMLNS = "";
XElement Inv = new XElement("Invoice",
from items in FileContent
let fields = items.Split(',')
select new XElement("Item",
new XElement("ID", fields[0]),
new XElement("Name", fields[1]),
new XElement("Price", fields[2]),
new XElement("Availability", fields[3]),
new XElement("TotalPrice", fields[4])
)
);
File.WriteAllText(@"C:\Temp\vba.xml", XMLNS + Inv.ToString() );
}
Here is the Input Text File
image: https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiqn6aFrvLkx9RZkbEHsX3hs5CgHHnjWd9JojseJMS3D__FqEovvcWUrqrWoYgPZ9G2ZhGPvCLhCEnQlNdcMEnP5JmAbHEW76WGqxOFDAeiHYl7Rng1mcWHzcBmOLaPmc1AsCsDQ9w6HjWm/s400/dnd_csv2xml1.JPG

The output XML looks like

image: https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjN7uTFGxx0gODhtn9UqSWJluPVcbT1nrnOcodDu3WHlSd514syk_ED53V3jfAsCbCp2OFTcy9XO-mOMSY3vOjzfAjG7kDkomdkTRxSXt7z74dpzt6BJ_WWAiRCJYgq4qpGprtC3OOyIeiY/s400/dnd_csv2xml2.JPG

Read more at http://dotnetdud.blogspot.com/2008/10/c-csv-to-xml-conversion-csv-to-xml.html#Aj2tQrpD5ELjLI8Z.99

Comments

Post a Comment

Popular posts from this blog

PHP, MySQL, JavaScript & HTML5 All-in-One For Dummies

Image
PHP, javascript, and HTML5 are essential programming languages for creating dynamic websites that work with the MySQL database. PHP and MySQL provide a robust, easy-to-learn, open-source solution for creating superb e-commerce sites and content management. javascript and HTML5 add support for the most current multimedia effects. This one-stop guide gives you what you need to know about all four! Seven self-contained mini books cover web technologies, HTML5 and CSS3, PHP programming, MySQL databases, javascript, PHP with templates, and web applications.
Read more

3 Best Applications that Organize your Chat and Messaging Accounts

Image
Vast of Instant Messaging (IM) platforms are made available in the internet nowadays. It helps every users to easily exchange messages, multimedia or even real-time virtual interaction with each other through computers and other portable devices. These mode of communication are somewhat important for everyone in this modern society and this applications plays a very essential and effective role in our daily living. Some of us are just busy interacting with people in such a way of bringing everyone closer, business matters, family, friends and others. Facebook Messenger, WeChat, Skype, Google Hangouts and Slack are just a few to mention of this platforms, it offers similar services but with quite different features. One has to sign up with these IM applications to start communicating and most of this services are being offered free. As of these days, people do have multiple accounts in different platforms, interacting people from different sides for different matters. As for me, I ...
Read more

Japan Style: Architecture Interiors Design

Image
Enter the world of the stylish Japanese house, where every object in sight is a work of art. Japan Style introduces 20 special residences. With more than 200 color photographs, this book showcases the stunning beauty of old homes, and reveals how they are cared for by their owners. Traditional Japanese homes, with superbly crafted fine wood, great workmanship and seasonal interior arrangements, have an aesthetic of infinite simplicity. Unlike Japanese inns and historical buildings, the houses featured in this book are private property and are not open to public viewing. Japan Style offers a rare glimpse into the intimate world of the everyday Japanese and fascinating insight into the traditional architecture of Japan download link http://libgen.io/_ads/E7F3D5D3E376CB1E116D00AFC8E89AC4 .
Read more