Reading xml

Question

Hello im a quite new c# developer and working on making a real simple weather app by using xml data. The xml : http://www.yr.no/sted/Norge/Akershus/Nesodden/Fjellstrand/varsel.xml What i would like to to is to pull out specific nodes like for example Weatherdata/Forecast/Tabular/ and then how to pull the data out from so that i only get time = 2010-12-16 Would really appreciate any help or guidelines ! :)

Suthish Nair · Answer

consider this example.. India Argentina Brazil Denmark Germany China Japan United Kingdom Switzerland Australia XDocument xDoc = XDocument.Load(Server.MapPath(Country.xml)); var xmlAtt = from att in xDoc.Elements(CountryList).Elements(Name) select att; foreach (var record in xmlAtt) { if (record.FirstAttribute.Value == 2) { comboBox1.Items.Add(record.Value); } } xDoc = null; xmlAtt = null; Mark the post as accepted answer

Daniel Golan · Answer

Got it ! thanks for the help :)

Suthish Nair · Answer

edited above post please check

Daniel Golan · Answer

Think im getting there :) How do i then use the example to populate a ComboList and when i choose one value can click a btn to get the xml data to a rich text box ?

Suthish Nair · Answer

Change it to Console.WriteLine Response is for web applications.

Daniel Golan · Answer

is Response a variable that is set ? Since getting error The name response does not exist in the current document

Daniel Golan · Answer

Thanks for the answer got it to work ! :) But when i use the combolist the values in the drop down is id=1 how can i filter away id= and only get the value ? Second thing how can i then use the value (1) to open the corresponding xml data so by using the example the output to txtbox would be : Name : Example Platform: PC xml example Example PC Example2 PC

Suthish Nair · Answer

try.. using System.Collections.Generic; using System.Xml.Linq; using System.Linq; XDocument xmlDoc = XDocument.Load(C:/Users/Daxal/Desktop/example/VideoGames.xml); var xmlAtt = from att in xmlDoc.Elements(Weatherdata/Forecast/Tabular/).Elements(time) select att; foreach (var record in xmlAtt) { //put breakpoint in record and check the value according to that baind the records Split the value at T and get first array value. }