Get the Element with highest value

[skea]

Linq2Xml:

[Edited]

I would like to get the count of elements where candidate has maximum/highest . I need some help.

 

<Pronvice_Data>
       <Pronvice>PronviceA</Pronvice>
       <Registered_Voters>115852</Registered_Voters>
       <Sam_Kea>100</Sam_Kea>
       <Jeje>500</Jeje>
       <John_Doe>400</John_Doe>
       </Pronvice_Data>
       
     <Pronvice_Data>
     <Pronvice>PronviceA</Pronvice>
   <Registered_Voters>25852</Registered_Voters>
   <Sam_Kea>200</Sam_Kea>
   <Jeje>100</Jeje>
   <John_Doe>300</John_Doe>
     </Pronvice_Data>
     
     <Pronvice_Data>
     <Pronvice>PronviceC</Pronvice>
     <Registered_Voters>317684</Registered_Voters>
     <Sam_Kea>1000</Sam_Kea>
     <Jeje>1200</Jeje>
     <John_Doe>190</John_Doe>
     </Pronvice_Data>

 

Expected Result:

 

Candidate | Won In
Jeje            2
John_Doe    1
Sam_Kea     0

Edited March 7, 2010 by skea

[skea]

Got it to work.