Finding a value within an xml segment using XmlReader in C#

Question

I am using XML reader to search through an xml configuration file we use. I want to find the values under a certain key and be able to change them or add if they don't exist.

XML Sample

<DBSimulatorConfigurations>
  <Configurations>
    <DBSimulatorConfiguration>
      <Key>Test1</Key>
      <Submit>0</Submit>
      <Amend>0</Amend>
      <Update>0</Update>
      <Delete>1</Delete>
    <ResponseTimeInSeconds>100</ResponseTimeInSeconds>
    </DBSimulatorConfiguration>
    <DBSimulatorConfiguration>
      <Key>Test2</Key>
      <Submit>0</Submit>
      <AutoUpdate>0</AutoUpdate>
      <Amend>0</Amend>
      <Update>0</Update>
      <Delete>1</Delete>
    <ResponseTimeInSeconds>100</ResponseTimeInSeconds>
    </DBSimulatorConfiguration>
    <DBSimulatorConfiguration>
  </Configurations> 
</DBSimulatorConfigurations>

Code so far... commented out bit doesn't find the value within 'Test1'

XmlReader reader = XmlReader.Create("C:\\<path>\\DBConfigs.xml");
while(reader.Read())
{
    if (reader.ReadToDescendant("Key"))
    {
        reader.Read();
        if (reader.Value == "Test1")
        {
            Console.WriteLine("Found_1 {0}", reader.Value);
            // Doesn't work :( 
            // reader.Read();
            //if (reader.ReadToDescendant("Submit")) {
            //  Console.WriteLine("Value for Submit is {0}", reader.Value);
            //}
        }

        if (reader.Value == "Test2")
        {
            Console.WriteLine("Found_2 {0}", reader.Value);
        }

        reader.Read(); //this moves reader to next node which is text 
        if (reader.ReadToDescendant("Full.2")) {
            Console.WriteLine("Found {0}", reader.Value);
        }

    }

But what I want to do then is find and change the value for 'Submit' or 'Amend' etc or if there is no entry 'Submit' then i'll add one.

But first i'd like to be able to find and change the values for Test1.

If you are modifying your XML, it's going to be much, much easier to use LINQ to XML to do so. See Linq to XML - update/alter the nodes of an XML Document or Update XML with C# using Linq to get started. — dbc
– dbc, Commented Jul 31, 2017 at 8:11
If you really, really want to do streaming transforms of XML using just XmlReader and XmlWriter you might start with Combining the XmlReader and XmlWriter classes for simple streaming transformations. — dbc
– dbc, Commented Jul 31, 2017 at 8:15

John · Accepted Answer · 2017-07-31 15:13:06Z

This appears to work to find value and update it. I've updated it so I can find any value for a particular value.

//search for  all nodes with <DBSimulatorConfiguration> element
string xml = "<path>.DBConfig.xml";
XDocument xdoc = XDocument.Load(xml);
var elements = xdoc.Root.Elements().Elements().Where(x => x.Name == "DBSimulatorConfiguration");
//iterate through all those eleemnt

foreach (var element in elements)
{
    //Console.WriteLine("Empty {0}", element.Value);
    //now find it's child named Submit
    var configKey = element.Elements().FirstOrDefault(x => x.Name == "Key");
    var configSubmit = element.Elements().FirstOrDefault(x => x.Name == "Submit");
    var configAmend = element.Elements().FirstOrDefault(x => x.Name == "Amend");
    var configUpdate = element.Elements().FirstOrDefault(x => x.Name == "Update");
    var configDelete = element.Elements().FirstOrDefault(x => x.Name == "Delete");

    //if such element is found
    if (configSubmit != null)
    {
        if (configKey.ElementsBeforeSelf().Any(x => x.Name == "Key" && x.Value == "Test1"))
        {
            Console.WriteLine("Found Key for Test1 {0}", configKey.Value);
        }
        if (configSubmit.ElementsBeforeSelf().Any(x => x.Name == "Key" && x.Value == "Test1"))
        {
            configSubmit.Value = "1";
            Console.WriteLine("Submit value is updated to {0}", configSubmit.Value);        
        }
        if (configAmend.ElementsBeforeSelf().Any(x => x.Name == "Key" && x.Value == "Test1"))
        {
            Console.WriteLine("Amend value is: {0}", configAmend.Value);
        }
        if (configUpdate.ElementsBeforeSelf().Any(x => x.Name == "Key" && x.Value == "Test1"))
        {
            Console.WriteLine("Update value is: {0}", configUpdate.Value);
        }
    }
}
xdoc.Save("<path>.DBConfig.xml");

Is this the most efficient way of doing this?

Nino · Accepted Answer · 2017-07-31 09:27:12Z

0

Here is one approach, using XDocument:

 string xml = @"
<DBSimulatorConfigurations>
  <Configurations>
    <DBSimulatorConfiguration>
      <Key>Test1</Key>
      <Submit>0</Submit>
      <Amend>0</Amend>
      <Update>0</Update>
      <Delete>1</Delete>
    <ResponseTimeInSeconds>100</ResponseTimeInSeconds>
    </DBSimulatorConfiguration>
    <DBSimulatorConfiguration>
      <Key>Test2</Key>
      <Submit>0</Submit>
      <AutoUpdate>0</AutoUpdate>
      <Amend>0</Amend>
      <Update>0</Update>
      <Delete>1</Delete>
    <ResponseTimeInSeconds>100</ResponseTimeInSeconds>
    </DBSimulatorConfiguration>
    <DBSimulatorConfiguration>
    </DBSimulatorConfiguration>
  </Configurations> 
</DBSimulatorConfigurations>";

XDocument xdoc = XDocument.Parse(xml);
//search for  all nodes with <DBSimulatorConfiguration> element
var elements = xdoc.Root.Elements().Elements().Where(x => x.Name == "DBSimulatorConfiguration");
//iterate through all those eleemnt
foreach (var element in elements)
{
    //now find it's child named Submit
    var submitElement = element.Elements().FirstOrDefault(x => x.Name == "Submit");
    //if such element is found
    if (submitElement != null)
    {
        //here you can change Submit element, like this:
        // submitElement.Value = "abc";
        //or you can check for something
        if (submitElement.ElementsBeforeSelf().Any(x=> x.Name == "Key" && x.Value== "Test2"))
        {
            //this is submitElement which is after element named Key with value Test2
            submitElement.Value = "some specific value";
        }
    }
    else
        element.Add(new XElement("Submit", 999));
}

answered Jul 31, 2017 at 9:27

Nino

7,1152 gold badges29 silver badges46 bronze badges

5 Comments

John Over a year ago

I am getting an error with code. "System.Xml.XmlException: Data at the root level is invalid. Line 1, position 1." The first lines of the xml file are: <DBSimulatorConfigurations> <Template></Template> <Configurations><DBSimulatorConfiguration>

Nino Over a year ago

@john your xml is not valid. XDocument expects valid xml. In fact, xml sample you provided in question was not valid either, it was missing closing DBSimulatorConfigurations node which I added. Xml in my answer should be valid and you can test code with it. To check your xml, you can use some of online tools like this one or this one

John Over a year ago

Both tools you listed below say my xml is valid. But I solved the issue by using XDocument.Load instead of XDocument.Parse

Nino Over a year ago

@John well, did my answer help you?

John Over a year ago

yes, thank you it was about 90% what i was looking for. I've added my final solution, but i can't tick my own solution as an answer for another few hours. So i'll just tick your answer.

Collectives™ on Stack Overflow

Finding a value within an xml segment using XmlReader in C#

2 Answers 2

Comments

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related