Hello,
I'm trying
to return the last 7 days of data from an xml web service but with no luck. Could someone please explain me
to how I would accomplish this? The XML is as follows:
<node>
<api>
<usagelist>
<usage day="2011-01-01">
<traffic name="total" unit="bytes">23579797</traffic>
</usage>
<usage day="2011-01-02">
<traffic name="total" unit="bytes">23579797</traffic>
</usage>
<usage day="2011-01-03">
<traffic name="total" unit="bytes">23579797</traffic>
</usage>
<usage day="2011-01-04">
<traffic name="total" unit="bytes">23579797</traffic>
</usage>
</usagelist>
</api>
</node>
EDIT
The data I want
to retrieve will be used
to populate a line graph. Specificly I require the day attribute value and the traffic element value for the past 7 days. At the moment, I have the code below in place, howevewr it's only showing the first day 7 times and traffic for the first day 7 times.
XDocument xDocument = XDocument.Parse(e.Result);
var values = from query in xDocument.Descendants("usagelist")
select new History
{
day = query.Element("usage").Attribute("day").Value,
traffic = query.Element("usage").Element("traffic").Value
};
foreach (History history in values)
{
ObservableCollection<LineGraphItem> Data = new ObservableCollection<LineGraphItem>()
{
new LineGraphItem() { yyyymmdd = history.day, value = double.Parse(history.traffic) },
new LineGraphItem() { yyyymmdd = history.day, value = double.Parse(history.traffic) },
new LineGraphItem() { yyyymmdd = history.day, value = double.Parse(history.traffic) },
new LineGraphItem() { yyyymmdd = history.day, value = double.Parse(history.traffic) },
new LineGraphItem() { yyyymmdd = history.day, value = double.Parse(history.traffic) },
new LineGraphItem() { yyyymmdd = history.day, value = double.Parse(history.traffic) },
new LineGraphItem() { yyyymmdd = history.day, value = double.Parse(history.traffic) },
};
lineGraph1.DataSource = Data;
}
