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;
        }