[RESOLVED] 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

[SambaNeko]

What language are you using to process the XML?

[menre]

I can see from your tags that you have an XML file in place. Do you wish to extract the values with JavaScript and be able to tell which element has the highest value? Or do you wish to use another means to know which element has the highest value? I know it is possible to do this with JavaScript. But could you confirm this or be more specific please?

[skea]

Hi, i am using C# and here is how i load my XML

XDocument xmlVectors2 = XDocument.Load(@"C:\\Province_Data.xml"); 
     var elemList= from elem in xmlVectors2.Descendants("Province_Data")
              where elem.Elements().Count() > 1 
              select elem;

There is a standing solution here http://stackoverflow.com/questions/2...didate-has-won, but my problem is to get my structured XML in the foreach act as the source XDocument. Somehow, i cant get way to save it.

[skea]

Got it to work.