How can I update password or other attributes in below XML using c#

Question

How can I update password or other attributes in connection string in XML using c# .

<?xml version="1.0"?>
<configuration>
    <connectionStrings>
        <add name="abcConnection" connectionString="server=10.10.12.12;database=Test1;uid=myUI‌D;password=hello;tim‌eout=20;"providerNam‌e="System.Data.SqlCl‌ient" />
        <add name="123Connection" connectionString="server=10.10.23.45;database=test2;uid=MyUS‌I;password=hello;" providerName="System.Data.SqlClient" />
    </connectionStrings>
</configuration>

it can be any xml file not the config from the same application . Please help.

Please post your xml in the question because it a lot cleaner. And you should write what you already tried. — Mighty Badaboom, Mar 21 '17 at 07:21
If you want generic xml reader then you've to make a parser by yourself. — M. Adeel Khalid, Mar 21 '17 at 07:34
Without any attempted code to start with, this question is a duplicate of any older "how to parse XML using C#" kinda questions... — har07, Mar 21 '17 at 07:36
I was able to update the attributes using XMLDocument but connection string attribute itself contains other attributes which I am not able to . — Raghvendra Yadav, Mar 21 '17 at 07:37
@RaghvendraYadav Then this question has nothing to do with XML. XML model recognize attribute value as a unit, i.e a string in your case. Once you managed to get the `connectionString` value, you need to do string manipulation operation to get/update specific part of the string i.e password — har07, Mar 21 '17 at 07:49

score 0 · Answer 1 · answered Mar 21 '17 at 07:52

You can Update your xml anyway:

use this reference:

 using System.IO;

use this code:

   var XMLpath = "c:\test.xml"; //<< your xml here
    if (!File.Exists(XMLpath))
    {
        using (StreamWriter XmlWrite = new StreamWriter(XMLpath, false))
        {
            string[] x = {@"<?xml version=""1.0""?>",
                           @"<configuration>",
                           @"<connectionStrings>",
                           @"<add name=""abcConnection"" connectionString=""server=10.10.12.12;database=Test1;uid=myUI‌D;password=hello;tim‌eout=20;""providerNam‌e=""System.Data.SqlCl‌ient"" />""",
                           @"<add name=""123Connection"" connectionString=""server=10.10.23.45;database=test2;uid=MyUS‌I;password=hello;"" providerName=""System.Data.SqlClient"" />",
                           @"</connectionStrings>",
                           @"</configuration>}";
            foreach (string s in x)
            {
                XmlWrite.WriteLine(s);
            }
        }
    }

How can I update password or other attributes in below XML using c#

1 Answers1