Append to xml file

Is there a way to read an XML file and then "append" a line to it with vb code?

Example...on a button click event, could I add this
<add key="strCon" value="user id=lrbrister;pwd=mypassword;data source=lrbrister_dell\;initial catalog=mydatabaser"/>


To this mysettings.config file
<appSettings>
  <add key="KeyToOverride" value="Overridden" />
  <add key="KeyToBeAdded" value="EntirelyNew" />
</appSettings>

So that the file would now look like this
<appSettings>
  <add key="KeyToOverride" value="Overridden" />
  <add key="KeyToBeAdded" value="EntirelyNew" />
  <add key="strCon" value="user id=lrbrister;pwd=mypassword;data source=lrbrister_dell\;initial catalog=mydatabaser"/>
</appSettings>
lrbristerAsked:
Who is Participating?
 
nepaluzConnect With a Mentor Commented:
Try
Dim XReader = XElement.Load(New System.IO.StreamReader("YourXMLFile"))
XReader.Element("appSettings").Add(<add key="strCon" value="user id=lrbrister;pwd=mypassword;data source=lrbrister_dell\;initial catalog=mydatabaser"/>)
XReader.Save("YourXMLFile")

Open in new window

0
 
lrbristerAuthor Commented:
Bewst "clean" answer
0
All Courses

From novice to tech pro — start learning today.