Linq2XML: Get the count of elements where candidate has won2

Posted by user287798 on Stack Overflow See other posts from Stack Overflow or by user287798
Published on 2010-03-08T00:55:30Z Indexed on 2010/03/08 1:01 UTC
Read the original article Hit count: 330

Filed under:

I had an XML Document in the format below

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

As suggested by help here,I used the code below to give me this format below C# Code:

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

    foreach(XElement element in elemList)
    {
      XElement elem1= new XElement("Candidates",
                       new XElement(element.Element("Sam_Kea").Name),
                       new XElement(element.Element("Jeje").Name),
                       new XElement(element.Element("John_Doe").Name)
                       );

       XElement elem2 = new XElement("Provinces",
                       new XAttribute("Province", (string)element.Element("Province").Value),
                       new XAttribute("Registered_Voters",element.Element("Registered_Voters").Value),              

                             new XElement
                                  ("Candidate",
                                  new XAttribute("Name",element.Element("Sam_Kea").Name),
                                  new XAttribute("Votes",element.Element("Sam_Kea").Value)                             
                                  ),
                              new XElement
                                   ("Candidate",
                                  new XAttribute("Name",element.Element("Jeje").Name),
                                  new XAttribute("Votes",element.Element("Jeje").Value)                            
                                  ),
                                   new XElement
                                   ("Candidate",
                                  new XAttribute("Name",element.Element("John_Doe").Name),
                                  new XAttribute("Votes",element.Element("John_Doe").Value)                            
                                  ));

    }
} 

New Format:

<root>
  <Candidates>
    <Sam_Kea/>
    <Jeje/>
    <John_Doe/>
  </Candidates>

  <Provinces>
    <Province name='ProvinceA' Registered_Voters='115852'>
      <Candidate name='Sam_Kea' votes='100'/>
      <Candidate name='Jeje' votes='500'/>
      <Candidate name='John_Doe' votes='400'/>
    </Province>

    <Province name='ProvinceB' Registered_Voters='25852'>
      <Candidate name='Sam_Kea' votes='200'/>
      <Candidate name='Jeje' votes='100'/>
      <Candidate name='John_Doe' votes='300'/>
    </Province>

    <Province name='ProvinceC' Registered_Voters='317684'>
      <Candidate name='Sam_Kea' votes='1000'/>
      <Candidate name='Jeje' votes='1200'/>
      <Candidate name='John_Doe' votes='190'/>
    </Province>
  </Provinces>

</root>

How can i use the "foreach" in in my code to get the result in this link. http://stackoverflow.com/questions/2396203/get-the-count-of-elements-where-candidate-has-won

© Stack Overflow or respective owner

Related posts about linq-to-xml