How to get XML information from a child in an Element with a attribute using XmlDocument in C#?

Question

<response>
  <payment loanType="thirtyYearFixed">
    <rate>4.09</rate>
    <monthlyPrincipalAndInterest>410</monthlyPrincipalAndInterest>
    <monthlyMortgageInsurance>54</monthlyMortgageInsurance>
  </payment>
</response>

My question is how do I get the information from rate, monthlyPrincipalAndInterest, and monthlyMortgageInsurance? I have tried every different way and have stopped with XDocument using the following code as my last resort prior to posting this:

Rate = root.SelectSingleNode("//response/payment[@loanType='thirtyYearFixed']/rate").InnerText;

This is just the code for the rate child element. I have get all information prior to this portion in the XML file I am parsing but I hit a brick wall with this and can't seem to figure it out. I've even used XMLNodeList with the base //response/payment[@loanType='thirtyYearFixed'] as the variable then nodeVar["rate"].InnerText and still got a null reference error.

I have a feeling this is going to be some small piece I over looked but I'm not only running out of options I'm running out of time.

Dylan · Accepted Answer · 2013-09-29 03:31:32Z

1

Maybe try something like this:

var xdoc = XDocument.Load(@"C:\Temp\doc.xml");
var node = xdoc.XPathSelectElements("./response/payment[@loanType='thirtyYearFixed']");
var query = from payment in  node             
            select new
            {
                rate                        = payment.XPathSelectElement("rate"),
                monthlyPrincipalAndInterest = payment.XPathSelectElement("monthlyPrincipalAndInterest"),
                monthlyMortgageInsurance    = payment.XPathSelectElement("monthlyMortgageInsurance")

            };

    foreach (var v in query)
    {
        Console.WriteLine(v.rate.Value);
        Console.WriteLine(v.monthlyPrincipalAndInterest.Value);
        Console.WriteLine(v.monthlyMortgageInsurance.Value);
    }

answered Sep 29, 2013 at 3:31

Dylan

1652 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Joe Kasavage Over a year ago

That would work out great! If only I hadn't made the huge mistake of putting XDocument instead of XmlDocument... Back to the drawing board for me.

Joe Kasavage Over a year ago

If I use this method with my HTTP response it comes out null, if I use just the URL of the generated file then it displays 0 for some reason.

Joe Kasavage Over a year ago

Problem has been resolved. Apparently there wasn't an error in my parsing, but an error in my HTTP request. Thanks for the help! The code above works PERFECTLY for getting the information needed.

Dylan Over a year ago

I'm glad to hear it. Please don't forget to mark my response as the answer.

Collectives™ on Stack Overflow

How to get XML information from a child in an Element with a attribute using XmlDocument in C#?

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related