XML Newbie help!

• • Reply

  10 years ago

  by dharry

  Dean Harry

  Melbourne, Australia

  Joined 10 years ago

  Hi All,

  I am pretty new to XML and struggling trying to extract some data from an XML document...

  Here is a snippet of the document:

  What I am trying to extract is the PoolType = "WW" and then within that the DivAmount and RunnerNo.

  I have been playing around with GetElementByName and Attributes but just can't seem to find the values.

  Any help would be greatly appreciated :)

  Cheers Dean

  Report abuse
• • Reply

  10 years ago

  by AmzBee

  Aimee Bailey

  Liverpool, United Kingdom

  Joined 10 years ago

  Heya, if you provide a snippet of the XML you are trying to parse, i'll see if i can show you how.

  Report abuse
• • Reply

  10 years ago

  by dharry

  Dean Harry

  Melbourne, Australia

  Joined 10 years ago

  Hi AmzBee,

  I did put it in here but it must have striped it... here it is again, or it it isn't there I have put it on pastebin.com as well :)

  Appreciate the help, it's doing my head in.

  Dean

  http://pastebin.com/deTEjt3L

  <ResultPlace PlaceNo="1">
  	<Result RunnerNo="6" PoolType="PP" Ref50Pct="N" RefScratched="N" RefAbandon="N" RefNoWinner="N" NoPlacePool="N">
  		<PoolResult PoolType="PP" Dividend="2.40"/>
  	</Result>
  	<Result RunnerNo="6" PoolType="WW" Ref50Pct="N" RefScratched="N" RefAbandon="N" RefNoWinner="N" NoPlacePool="N">
  		<PoolResult PoolType="WW" Dividend="10.00"/>
  	</Result>
  </ResultPlace>
  <ResultPlace PlaceNo="2">
  	<Result RunnerNo="3" PoolType="PP" Ref50Pct="N" RefScratched="N" RefAbandon="N" RefNoWinner="N" NoPlacePool="N">
  		<PoolResult PoolType="PP" Dividend="2.50"/>
  	</Result>
  	<Result RunnerNo="3" PoolType="WW" Ref50Pct="N" RefScratched="N" RefAbandon="N" RefNoWinner="N" NoPlacePool="N">
  		<PoolResult PoolType="WW"/>
  	</Result>
  </ResultPlace>
  <ResultPlace PlaceNo="3">
  	<Result RunnerNo="4" PoolType="PP" Ref50Pct="N" RefScratched="N" RefAbandon="N" RefNoWinner="N" NoPlacePool="N">
  		<PoolResult PoolType="PP" Dividend="1.20"/>
  	</Result>
  	<Result RunnerNo="4" PoolType="WW" Ref50Pct="N" RefScratched="N" RefAbandon="N" RefNoWinner="N" NoPlacePool="N">
  		<PoolResult PoolType="WW"/>
  	</Result>
  </ResultPlace>
  

  Report abuse
• • Reply

  10 years ago

  by AmzBee

  Aimee Bailey

  Liverpool, United Kingdom

  Joined 10 years ago

  To use this example, its important to note i added a single enclosing tag callled results arround your xml, this is so that the xml parser would not throw a tantrum...

  <results>
    <ResultPlace PlaceNo="1">
      <Result RunnerNo="6" PoolType="PP" Ref50Pct="N" RefScratched="N" RefAbandon="N" RefNoWinner="N" NoPlacePool="N">
        <PoolResult PoolType="PP" Dividend="2.40"/>
      </Result>
      <Result RunnerNo="6" PoolType="WW" Ref50Pct="N" RefScratched="N" RefAbandon="N" RefNoWinner="N" NoPlacePool="N">
        <PoolResult PoolType="WW" Dividend="10.00"/>
      </Result>
    </ResultPlace>
    <ResultPlace PlaceNo="2">
      <Result RunnerNo="3" PoolType="PP" Ref50Pct="N" RefScratched="N" RefAbandon="N" RefNoWinner="N" NoPlacePool="N">
        <PoolResult PoolType="PP" Dividend="2.50"/>
      </Result>
      <Result RunnerNo="3" PoolType="WW" Ref50Pct="N" RefScratched="N" RefAbandon="N" RefNoWinner="N" NoPlacePool="N">
        <PoolResult PoolType="WW"/>
      </Result>
    </ResultPlace>
    <ResultPlace PlaceNo="3">
      <Result RunnerNo="4" PoolType="PP" Ref50Pct="N" RefScratched="N" RefAbandon="N" RefNoWinner="N" NoPlacePool="N">
        <PoolResult PoolType="PP" Dividend="1.20"/>
      </Result>
      <Result RunnerNo="4" PoolType="WW" Ref50Pct="N" RefScratched="N" RefAbandon="N" RefNoWinner="N" NoPlacePool="N">
        <PoolResult PoolType="WW"/>
      </Result>
    </ResultPlace>
  </results>
  

  To read this xml in c#, you could do the following...

  public void ReadPools()
  {
      XmlDocument doc = new XmlDocument();
      doc.Load("results.xml");
  
      XmlNode results = doc.FirstChild;
  
      foreach (XmlNode node in results.ChildNodes)
      {
          int PlaceNo = int.Parse(node.Attributes["PlaceNo"].Value);
          string message = string.Format("Place No: {0}\n", PlaceNo);
  
          foreach (XmlNode result in node)
          {
              string PoolType = result.Attributes["PoolType"].Value;
              message += string.Format("Pool Type: {0}\n", PoolType);
          }
  
          MessageBox.Show(message);
      }
  
  }
  

  I hope this helps :)

  Aimee.

  Report abuse
• • Reply

  10 years ago

  by dharry

  Dean Harry

  Melbourne, Australia

  Joined 10 years ago

  Hi Aimee,

  That looks great thanks, but I am still struggling a little bit, maybe the whole XML feed might be a bit clearer... here is one of the feeds I get as an example. Now I have it all reading in fine and converting into an XmlDocument, I just dont understand how to get to the nodes and data properly :-S

  http://unitab.com/data/racing/2011/2/3/AG1.xml

  Regards, Dean

  Report abuse