Read xml error

Daniel Golan

15y10kLINQ

Hello, working on a code to read xml, got a hint that i cant use xdocument since not valid characters in the xml.
The purpose of the code is to use the value from he cmblist to find a specifific node and print it in a txt box. Would be very happy for any help :)
The xml :
http://www.yr.no/sted/Norge/Akershus/Nesodden/Fjellstrand/varsel.xml

The code
XDocument xmlDoc = XDocument.Load("C:/Users/Daxal/documents/visual studio 2010/Projects/Yr/Yr/fjellstrand.xml");

var games = from game in xmlDoc.Descendants("weatherdata")
where game.Element("forecast").Element("text").Element("location").Element("time").Attribute("from").Value == cmb_sted.SelectedItem.ToString()
select new
{ Title = game.Element("title").Value,
Body = game.Element("body").Value,
};

txt_result.Text = "";
foreach (var game in games)
{//write values in txt box
txt_result.Text = txt_result.Text + "Title : " + game.Title + "\n";
txt_result.Text = txt_result.Text + "Body : " + game.Body + "\n\n";
}
if (txt_result.Text == "")
txt_result.Text = "No Results.";

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Suthish Nair15y ago
Accepted answer
Add a reference to "System.Web.dll", import the 'System.Web' namespace and use 'HttpUtility.HtmlEncode'.
```
or using System.Web.HttpUtility;
```
Daniel Golan15y ago
Yay ! working :) just gotta sort them by selection
Daniel Golan15y ago
Error on 'Server'
"The name 'Server' does not exist in the current context"

Console.Write(Server.Current.HtmlDecode(record.Value) + "
");
Suthish Nair15y ago
using System.Xml.XPath;
Daniel Golan15y ago
At first look i get error at XPathSelectElements and server.

Suthish Nair15y ago

You still having the issue?

XDocument example, not tested. try it out.

XDocument xDoc = XDocument.Load(Server.MapPath("1.xml"));
IEnumerable names = xDoc.XPathSelectElements("weatherdata/forecast/text/location/time").Descendants();

var xmlAtt = from att in names
             select att;
        
foreach (var record in xmlAtt)
{
   Response.Write(Server.HtmlDecode(record.Value) + "
");
}
   xDoc = null;  names = null; xmlAtt = null;