Create summary from xml

[Rookie]

I have the next challenge.
I read in an xml file and read two relevant attributes from an element.
So far so good.

But after reading the xml file i want to create a report with the values of
the attributes and the occurences (create a summary).

for example:

Attribute Value Occurence
--------- ------ -----------

name John 10
Jessica 3
Abby 15
. . .

state Alabama 5
Georgia 15
Montana 30
. . .

I suppose i need to to use some two dimensional collection, but which one
and how to deal with the occurences.
(add, replace, updtate items ??)

Thanks in advance,

Rookie

 

[Sharon]

Hi,
I would use LINQ to XML grouping capabilities.
Or, if you already parsed the XML to a collection,
You can use LINQ to Objects.


http://msdn.microsoft.com/en-us/library/bb387098.aspx
http://msdn.microsoft.com/en-us/library/bb397919.aspx

 

[Robertico]

thx. Fixed.

Rookie

Hi,
I would use LINQ to XML grouping capabilities.
Or, if you already parsed the XML to a collection,
You can use LINQ to Objects.


http://msdn.microsoft.com/en-us/library/bb387098.aspx
http://msdn.microsoft.com/en-us/library/bb397919.aspx