[RESOLVED] get values from xml elements

[Darkmatter5]

Here's a portion of my XML string.

<OpenSearchDescription>
<opensearch:Query searchTerms="Star Wars"/>
<opensearch:totalResults>18</opensearch:totalResults>

Here's my code:

Dim xml As String = tmdb_.Movie_search(tbTitle.Text, cbYear.Text)
Dim xdoc As XDocument = XDocument.Parse(xml)

lbResults.Text = xdoc.Element("totalResults").Value.ToString

The line "Dim xml As String = tmdb_.Movie_search(tbTitle.Text, cbYear.Text)" produces a string with the entire xml return. How do I go about setting lbResult.Text to "18" or the value of "<opensearch:totalResults>"

Thanks!

[Darkmatter5]

No ideas?

[nbrege]

I think you need to specify the full Xpath. Maybe something like:

lbResults.Text = xdoc.Element("OpenSearchDescription").Element("opensearch:totalResults").Value

And you dont need the .ToString at the end as .Value is already a string.

[Darkmatter5]

Thanks for the reply, but running it I get the following error.

"The ':' character, hexadecimal value 0x3A, cannot be included in a name."

Any thoughts?

[Darkmatter5]

I've been reading that I need to use a XNamespace, how would I go about doing this?

[Darkmatter5]

Woohoo I did it.

Imports <xmlns="http://a9.com/-/spec/opensearch/1.1/">

In the function:
Dim xname As XNamespace = "http://a9.com/-/spec/opensearch/1.1/"
lbResults.Text = xdoc.Element("OpenSearchDescription").Descendants(xname + "totalResults").Value