I am trying to lookup a track and append it to an existing list of tracks in an XML file but I am not having any success with my code. Could anyone help?

Thanks

        Dim sPath = "c:\track.xml"
        Dim doc = New XmlDocument()

        If File.Exists(sPath) Then
            doc.Load(sPath)
  
            Dim data = From t In MyCTXHelper.ctx.Tracks Where t.trackId = trackName

            Dim track = From t In MyCTXHelper.ctx.Tracks Where t.trackId = trackName _
                        Select <track id=<%= t.trackId %>>
                                   <trackName><%= t.trackName %></trackName>
                                   <trackNumber><%= t.trackNumber %></trackNumber>
                                   <releaseYear><%= t.releaseYear %></releaseYear>
                               </track>

            doc.Save(sPath)

Hi Ruffone ,

I do not find any code to do inserting from your post.

So here is one good sample about how to insert element,

//Create dummy XML to work

var root = new XElement("parent",

    from i in new int[] { 1, 2, 3, 4, 5, 6 }

    select new XElement("child",

        new XAttribute("number", i)));

This will create XML like,

<?xmlversion="1.0"encoding="utf-8"?>

<parent>

 <childnumber="1" />

 <childnumber="2" />

 <childnumber="3" />

 <childnumber="4" />

 <childnumber="5" />

 <childnumber="6" />

</parent>

Samu Zhang thanks for your response,
This is what I want to do. How would I add this entire "track" element to the document? Or do I have to string it togather node by xmlNode.

Thanks

<?xml version="1.0" encoding="utf-8"?>
<tracks>
  <track id="40">
    <trackId>40</trackId>
    <trackName>Tell Me</trackName>
    <trackNumber>3</trackNumber>
    <releaseYear>2002</releaseYear>
    <performers>
      <performer>
        <personId>2</personId>
        <personName>Benie</personName>
        <artistFeaturing>N</artistFeaturing>
      </performer>
    </performers>
  </track>
</tracks>



                Dim dd = <track id="45">
                             <trackId>45</trackId>
                             <trackName>Tell Me</trackName>
                             <trackNumber>5</trackNumber>
                             <releaseYear>2002</releaseYear>
                             <performers>
                                 <performer>
                                     <personId>2</personId>
                                     <personName>Benie</personName>
                                     <artistFeaturing>N</artistFeaturing>
                                 </performer>
                             </performers>
 
                         </track>

XDocument instead of XmlDocument made all the difference. This now works

        Dim sPath = "c:\track.xml"
        Dim doc As XDocument

        If File.Exists(sPath) Then
            doc = XDocument.Load(sPath)
  
            Dim data = From t In MyCTXHelper.ctx.Tracks Where t.trackId = trackName

            Dim track = From t In MyCTXHelper.ctx.Tracks Where t.trackId = trackName _
                        Select <track id=<%= t.trackId %>>
                                   <trackName><%= t.trackName %></trackName>
                                   <trackNumber><%= t.trackNumber %></trackNumber>
                                   <releaseYear><%= t.releaseYear %></releaseYear>
                               </track>

            Dim Tracks = doc.<tracks>.<track>
            Tracks.Last().AddAfterSelf(track)
            doc.Save(sPath)