C# VS 2008 3.5 XML/Webservice error

[realJSOP]

The most glaring thing is the hyphens before the root tags. Further, your code should probably look more like this:

XElement element = Results.Elements("NewDataSet").Element("Table");
string city = element.Element("CITY").Value;
string state = element.Element("STATE").Value;
... blah blah

.45 ACP - because shooting twice is just silly
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001

[Wheels012]

The problem I am having now is that th eLoad is looking for a physical XML file on my computer, but it is being called from a Web Service.

XDocument doc = XDocument.Load(ws.GetInfoByZIP(txtZip.Text).ToString());

private void btnZipWS_Click(object sender, EventArgs e)
{

        Bank.net.webservicex.www.USZip ws = new Bank.net.webservicex.www.USZip();

       
        XDocument doc = XDocument.Load(ws.GetInfoByZIP(txtZip.Text).ToString());
                 XElement element = Results.Elements("NewDataSet").Element("Table"); 
        string city = element.Element("CITY").Value; 
        string state = element.Element("STATE").Value;

WHEELS

[realJSOP]

Since you're getting an XML string back from the web service, you want to use this:

XDocument doc = XDocument.Parse(textZip.Text);

.45 ACP - because shooting twice is just silly
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001

[Wheels012]

Hi John. I am semi-following. I wouldn't be parsing the txtZip.Text. That is a textbox on the form and the data is being passed to the WS call.

XDocument doc = XDocument.Parse(ws.GetInfoByZIP(txtZip.Text).ToString());

When I use this, I am getting this error: Data at the root level is invalid. Line 1, position 1. WHEELS

[realJSOP]

Like I said in my original response - you have hyphens preceding the two root-most elements. That makes your XML invalid.

.45 ACP - because shooting twice is just silly
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001

[Wheels012]

Very new to XML. What do I do to compensate for the - s? WHEELS

[Luc Pattyn]

it is not valid XML as long as those hyphens are there. Eradicate them. :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

---

Prolific encyclopedia fixture proof-reader browser patron addict?
We all depend on the beast below.

---

[Wheels012]

Thank you Luc.

[realJSOP]

Isn't that what I told you, too?

.45 ACP - because shooting twice is just silly
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001

[Wheels012]

Hi John. I believe you did. Having a very challenging time with this XML/WebService, and didn't expect to enough these hypens. Thanks again. WHEELS

[realJSOP]

I'm working on a project as we speak that's getting XML from a SQL database stored procedure via a web service, and I'm not getting any hyphens. Can I assume you solved your problem?

.45 ACP - because shooting twice is just silly
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001

[Wheels012]

Found a work around, although not as elegant as I would like:

Bank.net.webservicex.www.USZip ws = new Bank.net.webservicex.www.USZip();

        XmlNode cityNode = ws.GetInfoByZIP(txtZip.Text);

        string cityName = "UNKNOWN";
        string stateName = "UNKNOWN";
        foreach (XmlNode node in cityNode)
        {
            foreach (XmlElement elem in node)
            {
                if (elem != null && elem.Name.Equals("CITY"))
                {
                    cityName = elem.FirstChild.InnerText;
                }
                if (elem != null && elem.Name.Equals("STATE"))
                {
                    stateName = elem.FirstChild.InnerText;
                }
            }
        }
        txtCity.Text = cityName;
        txtState.Text = stateName; 

WHEELS