Convert comma separated value to Xml : XElement « XML LINQ « VB.Net






  1. VB.Net
  2. XML LINQ
  3. XElement

Convert comma separated value to Xml

    


Imports System
Imports System.Xml.Linq
Imports Microsoft.VisualBasic.FileIO
Imports System.Text
Imports System.IO

    Public Class MainClass

        Public Shared Sub Main(ByVal args As String())
            Dim xmlTree As XElement
            Using parser As TextFieldParser = My.Computer.FileSystem.OpenTextFieldParser("data.txt")
                parser.TextFieldType = FieldType.Delimited
                parser.Delimiters = New String() {","}
                parser.HasFieldsEnclosedInQuotes = True

                xmlTree = <Employees></Employees>

                Dim currentRow As String()
                Do While Not parser.EndOfData
                    currentRow = parser.ReadFields
                    xmlTree.Add(<Employee id=<%= currentRow(0) %>>
                                    <Name><%= currentRow(1) %></Name>
                                    <Title><%= currentRow(2) %></Title>
                                    <HireDate><%= currentRow(3) %></HireDate>
                                    <HourlyRate><%= currentRow(4) %></HourlyRate>
                                </Employee>)
                Loop
            End Using
            Console.WriteLine(xmlTree)
        End Sub
    End Class








Related examples in the same category

1.Build an XElement from string
2.Create a single XML element
3.After elements
4.Before elements
5.Create an in-memory XML document
6.First name element has attributes
7.First name tag has child elements
8.FirstLast Or Default Example
9.First Last Example
10.FirstName tag's parent has child elements
11.Get first descendant
12.Using Xml Linq to output Html
13.Xml Literal with string variable
14.Xml literal with function return
15.Enumerate over the array to build an XElement
16.Create a query to convert the xml data into fields delimited by quotes and commas.
17.Get child elements by name directly
18.Get value of each color using indexer
19.Is FirstName tag empty?
20.Is idperson tag empty?
21.Using Ling query to create Xml output
22.The Root property returns the top-level XElement
23.Set new value to Xml document
24.Selects an XElement using a XPath expression.
25.XElement Represents an XML element.
26.Selects an XElement using a XPath expression.
27.XElement Class represents an XML element.
28.Create XElement class.
29.Create XElement class from another XElement object.
30.Create XElement class with the specified name.
31.Create XElement class with the specified name and content.
32.XElement object content
33.XElement object array content
34.Create XElement class with the specified name and content.
35.Create XElement class from an XStreamingElement object.
36.XElement.AncestorsAndSelf Method returns a collection of elements that contain this element, and the ancestors of this element.
37.XElement.AncestorsAndSelf (XName) returns a filtered collection of elements
38.XElement.Attributes returns a collection of attributes of this element.
39.XElement.Attributes (XName) returns a filtered collection of attributes of this element
40.XElement.DescendantNodesAndSelf returns nodes that contain this element, and all descendant nodes
41.XElement.HasAttributes tells whether this element as at least one attribute.
42.XElement.HasElements tells whether this element has at least one child element.
43.XElement.IsEmpty tells whether this element contains no content.
44.XElement.LastAttribute gets the last attribute of this element.
45.XElement.Name Property gets or sets the name of this element.
46.XElement.NodeType Property gets the node type for this node.
47.XElement.SetValue sets the value of this element.
48.XElement.Value Property gets or sets the concatenated text contents of this element.
49.Imports xmlns and use it with XElement
50.XObject.Parent Property gets the parent XElement of this XObject.
51.Extensions.AncestorsAndSelf
52.Extensions.Descendants
53.Extensions.Descendants(T)
54.Extensions.Elements(T) returns a collection of the child elements
55.Extensions.Elements(T) returns a filtered collection of the child elements
56.Extensions.XPathEvaluate evaluates an XPath expression.
57.String content
58.Double content
59.DateTime content
60.String array content
61.Returns elements containing this element and all descendant elements
62.Returns a filtered collection of elements containing this element and all descendant elements of this element
63.Get Ancestors