cant get linq to xml to read my xml doc

Question

0.00/5 (No votes)

See more:

this is the xml listing.xml

using linq to xml it never returns Elements from the query listing.Descendants("StreetName")

here is the code snippet

string queryURI = "http://retsgw.flexmls.com/rets2_0/Search?SearchType=Property&Class=A&QueryType=DMQL2&Query=(LIST_105=4123192)&Count=0&Format=STANDARD-XML&StandardNames=0&RestrictedIndicator=****&Limit=1@Select=LIST_105";
      HttpWebRequest req2 = (HttpWebRequest)WebRequest.Create(queryURI);
      req2.AuthenticationLevel = System.Net.Security.AuthenticationLevel.MutualAuthRequested;
      req2.Credentials = new NetworkCredential("---", "---"); //This line ensures the request is processed through Basic Authentication
      req2.ContentType = "text/xml" ;
      req2.Accept = "text/xml" ;
      req2.Method = "Post" ;
      HttpWebResponse response = (HttpWebResponse)req2.GetResponse();
      StreamReader reader = new StreamReader(response.GetResponseStream());
      string xml = reader.ReadToEnd();


          XDocument listing = XDocument.Parse(xml);
          var streetAddresses = from streetAddress in listing.Descendants("StreetAddress")

                                select new
                                {
                                    streetNumber = streetAddress.Element("StreetNumber").Value,
                                    streetDirPrefix = streetAddress.Element("StreetDirPrefix").Value,
                                    streetName = streetAddress.Element("StreetName").Value,
                                    streetsuffix = streetAddress.Element("StreetSuffix").Value,

                                    City = streetAddress.Element("City").Value,
                                    postalCode = streetAddress.Element("PostalCode").Value
                                };

Posted 29-Aug-10 10:20am

69stephen

Updated 29-Aug-10 10:21am

v2

Add a Solution

Comments

Christian Graus 29-Aug-10 16:25pm

I suspect it would help to see your XML.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Al-Farooque Shubho · Answer 1 · 2010-08-29T16:32:00

Finally I was able to find the problem and and fix accordingly (Initially, I thought this was a NameSpace related problem).

You should actually filter the LinQ expression with a condition : where streetAddress.Element("StreetNumber") != null

Here is the correct LinQ that you should use:

C#

var streetAddresses = from streetAddress in listing.Descendants("StreetAddress")
                      where streetAddress.Element("StreetNumber") != null
                      select new
                      {
                          streetNumber = streetAddress.Element("StreetNumber").Value,
                          streetDirPrefix = streetAddress.Element("StreetDirPrefix").Value,
                          streetName = streetAddress.Element("StreetName").Value,
                          streetsuffix = streetAddress.Element("StreetSuffix").Value,
                          City = streetAddress.Element("City").Value,
                          postalCode = streetAddress.Element("PostalCode").Value
                      };

The filtering had to be added because, the listing.Descendants("StreetAddress") actually returns two elements where one element does not have any child element and hence the expression gets null exception.