Update the node value of XML file

Manoj Bisht · February 10th, 2009, 02:08 AM

Hello Friends,

I've a XML file as shown below i want to update the path of the flv files which i've made bold below. Actually i've a playlist and my video player takes the properties from this XML file so i've to play the different different video which i click on.

<CONFIG>
−
<SETTINGS>
<PLAYER_SETTINGS Name="SelectedSkin" Value="../Files/Skins/flvplayer/skin.swf"/>
<PLAYER_SETTINGS Name="SelectedLoader" Value="../Files/Skins/flvplayer/loading.swf"/>

<PLAYER_SETTINGS Name="FLVPath" Value="http://localhost:4718/VideosUploading/Files/Videos/2.flv"/>

</SETTINGS>
</CONIG>

PeterPeiGuo · February 14th, 2009, 12:11 PM

look up DOM and xpath in c#.

JohnBampton · February 16th, 2009, 08:57 AM

Forget DOM and xpath that's old school. Use LINQ. Just use something like this.

Code:

XDocument xml = XDocument.Load(@"C:\XMLFile1.xml");
            var query = from p in xml.Elements("CONFIG").Elements("SETTINGS").Elements("PLAYER_SETTINGS")
                        where (string)p.Attribute("Name") == "FLVPath"
                        // and ....
                        select p;

            foreach (var record in query)
            {
                record.SetAttributeValue("Value", "new path");
            }

Cheers, John Bampton.

PeterPeiGuo · February 16th, 2009, 11:52 PM

To be honest, this is simply ugly. If you really into LINQ, then write this in LINQ to XSD instead of LINQ to XML.

Between XQuery and LINQ to XSD, they are too close to be compared just based on the face value. With .Net, LINQ obviously provides some consistancy between different types of objects being queried against.

PeterPeiGuo · February 19th, 2009, 09:02 AM

I was porbably ahead of myself with LINQ to XSD, not sure whether it's part of VS2008 and .Net 3.5.

JohnBampton · February 19th, 2009, 09:12 AM

I gave the solution and you bashed it. you were wrong

PeterPeiGuo · February 19th, 2009, 09:36 AM

It had nothing to do with your solution. LINQ to XML is not type safe when compared to LINQ to XSD, and I don't believe you can argure that. Perl is ugly, but many have written beautiful code in it, see what I mean?