|
-
Apr 15th, 2011, 10:05 AM
#1
Thread Starter
New Member
Linq to XML elments
Linq to Xml get elementat
Sorry for the long XML sample below. The XML sample below has two records and each record has three similar Nodes (<datafield tag="500" ) What I want to accomplish is get the value of the second Node <datafield tag = “5000”>. The fallowing code I gets the value for all three nodes but I want something like get elementat(1). Appreciate your help.
I tried this but it didn’t worked MsgBox(xEle.Elements.ElementAt(1).Value)
Dim xd As XDocument = XDocument.Load("C:\Users\stopete\Desktop\Marc_conv ertxml.xml")
If xd IsNot Nothing Then
Dim datafields = From datafield In xd.Descendants("datafield")
Where (datafield.Attribute("tag").Value = "500")
Select datafield
For Each xEle In datafields
MsgBox(xEle)
Next
End If
XML:
<?xml version="1.0"?>
<collection>
<record>
<leader>03799cam 2200493Ia 4500</leader>
<controlfield tag="001">648168072
<subfield code="a">Battle, Stephen L.</subfield>
</controlfield>
<controlfield tag="003">SIRSI</controlfield>
<controlfield tag="005">20110207150903.0</controlfield>
<controlfield tag="008">100716s2010 caub bm f000 0 eng d</controlfield>
<controlfield tag="007">cr b|||||a||||</controlfield>
<datafield tag="035" ind1=" " ind2=" ">
<subfield code="a">AD#</subfield>
<subfield code="c">AD#</subfield>
<subfield code="d">AD#</subfield>
</datafield>
<datafield tag="037" ind1=" " ind2=" ">
<subfield code="a">hey</subfield>
</datafield>
<datafield tag="040" ind1=" " ind2=" ">
<subfield code="a">ADA524509</subfield>
<subfield code="b">DTI</subfield>
</datafield>
<datafield tag="043" ind1=" " ind2=" ">
<subfield code="a">n-us---</subfield>
</datafield>
<datafield tag="049" ind1=" " ind2=" ">
<subfield code="a">AD#A</subfield>
</datafield>
<datafield tag="100" ind1="1" ind2=" ">
<subfield code="a">Battle, Stephen L.</subfield>
</datafield>
<datafield tag="245" ind1="1" ind2="0">
<subfield code="a">Lessons in legitimacy</subfield>
<subfield code="h">[electronic resource] :</subfield>
<subfield code="b">the LTTE end-game of 2007--2009 /</subfield>
<subfield code="c">Stephen L. Battle.</subfield>
</datafield>
<datafield tag="260" ind1=" " ind2=" ">
<subfield code="a">Monterey, California :</subfield>
<subfield code="b">Naval Postgraduate School,</subfield>
<subfield code="c">2010.</subfield>
</datafield>
<datafield tag="300" ind1=" " ind2=" ">
<subfield code="a">xiv, 57 p. :</subfield>
<subfield code="b">ill. (1 col map) ;</subfield>
<subfield code="c">28 cm.</subfield>
</datafield>
<datafield tag="500">
<subfield code="a">Thesis Advisor(s): Borer, Douglas A. ; Second Reader: Chatterjee, Anshu.</subfield>
</datafield>
<datafield tag="500">
<subfield code="a">"June 2010."</subfield>
</datafield>
<datafield tag="500">
<subfield code="a">Author(s) subject terms: LTTE, Counter Insurgency, COIN, Sri Lanka, Tamil Eelam, Eelam War IV, SLAF, South Asia.</subfield>
</datafield>
</record>
<record>
<leader>02919cam 2200493Ia 4500</leader>
<controlfield tag="001">648167554</controlfield>
<controlfield tag="003">SIRSI</controlfield>
<controlfield tag="005">20110207150310.0</controlfield>
<controlfield tag="008">100716s2010 caua bm f000 0 eng d</controlfield>
<controlfield tag="007">cr b|||||a||||</controlfield>
<datafield tag="035" ind1=" " ind2=" ">
<subfield code="a">AD#</subfield>
<subfield code="c">AD#</subfield>
<subfield code="d">AD#</subfield>
</datafield>
<datafield tag="037" ind1=" " ind2=" ">
<subfield code="a">hey</subfield>
</datafield>
<datafield tag="040" ind1=" " ind2=" ">
<subfield code="a">ADA524541</subfield>
<subfield code="b">DTI</subfield>
</datafield>
<datafield tag="043" ind1=" " ind2=" ">
<subfield code="a">n-us---</subfield>
</datafield>
<datafield tag="049" ind1=" " ind2=" ">
<subfield code="a">AD#A</subfield>
</datafield>
<datafield tag="100" ind1="1" ind2=" ">
<subfield code="a">Battaglia, Neal F.</subfield>
</datafield>
<datafield tag="245" ind1="1" ind2="0">
<subfield code="a">Utility of satellite LIDAR waveform data in shallow water</subfield>
<subfield code="h">[electronic resource] /</subfield>
<subfield code="c">Neal F. Battaglia.</subfield>
</datafield>
<datafield tag="260" ind1=" " ind2=" ">
<subfield code="a">Monterey, California :</subfield>
<subfield code="b">Naval Postgraduate School,</subfield>
<subfield code="c">2010.</subfield>
</datafield>
<datafield tag="300" ind1=" " ind2=" ">
<subfield code="a">xvi, 67 p. :</subfield>
<subfield code="b">ill. (some col.) ;</subfield>
<subfield code="c">28 cm.</subfield>
</datafield>
<datafield tag="500">
<subfield code="a">Thesis Advisor(s): Olsen, Richard C. ; Second Reader: Trask, David M.</subfield>
</datafield>
<datafield tag="500">
<subfield code="a">"June 2010."</subfield>
</datafield>
<datafield tag="500”>
<subfield code="a">Author(s) subject terms: LIDAR Waveforms, Underwater LIDAR signature, Spaceborne LIDAR.</subfield>
</datafield>
</record>
</collection>
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|