Databases
StackOverflow2013
Postsdbo
POLinq to XML C# Descendants: How to read Attributes with the same name?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POLinq to XML C# Descendants: How to read Attributes with the same name?
    primarykey
    data
    text
    <p>I search the Web and found many answers, but they all worked with a specific class or written in another way.</p> <p>I have this XML-Response:</p> <pre><code>&lt;return xsi:type="ns1:PlentySoapResponse_GetItemsBase"&gt; &lt;ItemsBase xsi:type="ns1:ArrayOfPlentysoapobject_itembase"&gt; &lt;item xsi:type="ns1:PlentySoapObject_ItemBase"&gt; &lt;ItemID xsi:type="xsd:int"&gt;2&lt;/ItemID&gt; &lt;ItemNo xsi:type="xsd:string"/&gt; ............. &lt;DeepLink xsi:type="xsd:string"&gt;/a-2/&lt;/DeepLink&gt; &lt;/item&gt; &lt;item xsi:type="ns1:PlentySoapObject_ItemBase"&gt; &lt;ItemID xsi:type="xsd:int"&gt;4&lt;/ItemID&gt; &lt;ItemNo xsi:type="xsd:string"/&gt; </code></pre> <p>And i read it this way:</p> <pre><code>XDocument loaded = XDocument.Parse(readString); for (int i = 0; i &lt; 50; i++) { var items = from x in loaded.Descendants("return") select new { ItemID = x.Descendants("ItemID").First().Value, Name = x.Descendants("Name").First().Value, EKnet = x.Descendants("PurchasePriceNet").First().Value }; foreach (var x in items) { item[i, 0] = x.ItemID.ToString(); item[i, 1] = x.Name.ToString(); item[i, 2] = x.EKnet.ToString(); } } else { MessageBox.Show("Wrong XML Call"); } return item; } </code></pre> <p>But I always get the same item Attributes.</p> <p>Is there an easy way to get the next Item Attributes? I read an exmaple with "IEnumerable" but this always uses a specific class, wich I dont want to use.</p> <p>Many thanks in advance.</p> <p>Edit:</p> <pre><code>&lt;SOAP-ENV:Body&gt; &lt;ns1:GetItemsBaseResponse&gt; &lt;return xsi:type="ns1:PlentySoapResponse_GetItemsBase"&gt; &lt;ItemsBase xsi:type="ns1:ArrayOfPlentysoapobject_itembase"&gt; &lt;item xsi:type="ns1:PlentySoapObject_ItemBase"&gt; &lt;ItemID xsi:type="xsd:int"&gt;2&lt;/ItemID&gt; &lt;ItemNo xsi:type="xsd:string"/&gt; &lt;ExternalItemID xsi:type="xsd:string"/&gt; &lt;EAN1 xsi:type="xsd:string"&gt;0023272005641&lt;/EAN1&gt; &lt;EAN2 xsi:type="xsd:string"/&gt; &lt;EAN3 xsi:type="xsd:string"/&gt; &lt;EAN4 xsi:type="xsd:string"/&gt; &lt;ISBN xsi:type="xsd:string"/&gt; &lt;ASIN xsi:type="xsd:string"&gt;B000NTAG66&lt;/ASIN&gt; &lt;Type xsi:type="xsd:int"&gt;0&lt;/Type&gt; &lt;Model xsi:type="xsd:string"/&gt; &lt;ProducerID xsi:type="xsd:int"&gt;0&lt;/ProducerID&gt; &lt;VATInternalID xsi:type="xsd:int"&gt;0&lt;/VATInternalID&gt; &lt;Marking1ID xsi:type="xsd:int"&gt;0&lt;/Marking1ID&gt; &lt;Marking2ID xsi:type="xsd:int"&gt;11&lt;/Marking2ID&gt; &lt;CustomsTariffNumber xsi:type="xsd:string"/&gt; &lt;FSK xsi:type="xsd:int"&gt;0&lt;/FSK&gt; &lt;Condition xsi:type="xsd:int"&gt;0&lt;/Condition&gt; &lt;Position xsi:type="xsd:string"/&gt; &lt;StorageLocation xsi:type="xsd:int"&gt;0&lt;/StorageLocation&gt; &lt;WebShopSpecial xsi:type="xsd:string"&gt;0&lt;/WebShopSpecial&gt; &lt;Published xsi:type="xsd:int"&gt;0&lt;/Published&gt; &lt;LastUpdate xsi:type="xsd:int"&gt;1344392167&lt;/LastUpdate&gt; &lt;ItemURL xsi:nil="true"/&gt; &lt;EbayEPID xsi:type="xsd:string"/&gt; &lt;ParcelServicePresetIDs xsi:type="ns1:ArrayOfPlentysoapobject_integer"&gt; &lt;item xsi:type="ns1:PlentySoapObject_Integer"&gt; &lt;intValue xsi:type="xsd:int"&gt;21&lt;/intValue&gt; &lt;/item&gt; &lt;/ParcelServicePresetIDs&gt; &lt;ProducingCountryID xsi:type="xsd:int"&gt;1&lt;/ProducingCountryID&gt; &lt;FreeTextFields xsi:type="ns1:PlentySoapObject_ItemFreeTextFields"&gt; &lt;Free1 xsi:type="xsd:string"/&gt; &lt;Free2 xsi:type="xsd:string"&gt;&lt;![CDATA[http://games.shop.ebay.de/PC-Videospiele-/1249/i.html?LH_BIN=1&amp;LH_ItemCondition=11&amp;Plattform=Xbox%2520360&amp;_trkparms=65%253A12%257C66%253A2%257C39%253A1%257C72%253A4674&amp;rt=nc&amp;_nkw=star+wars+force+unleashed&amp;_catref=1&amp;_dmpt=de_entertainment_games&amp;_trksid=p3286.c0.m14&amp;_sop=15&amp;_sc=1]]&gt;&lt;/Free2&gt; &lt;Free3 xsi:type="xsd:string"/&gt; &lt;Free4 xsi:type="xsd:string"&gt;1&lt;/Free4&gt; &lt;Free5 xsi:type="xsd:string"&gt;UK-Import: Spiel in Deutsch, Anleitung in Englisch&lt;/Free5&gt; &lt;Free6 xsi:type="xsd:string"&gt;Actionspiele&lt;/Free6&gt; &lt;Free7 xsi:type="xsd:string"&gt;XBOX 360&lt;/Free7&gt; &lt;Free8 xsi:type="xsd:string"&gt;ages_12_and_over&lt;/Free8&gt; &lt;Free9 xsi:type="xsd:string"/&gt; &lt;Free10 xsi:type="xsd:string"&gt;1&lt;/Free10&gt; &lt;Free11 xsi:type="xsd:string"&gt;0&lt;/Free11&gt; &lt;Free12 xsi:nil="true"/&gt; &lt;Free13 xsi:nil="true"/&gt; &lt;Free14 xsi:nil="true"/&gt; &lt;Free15 xsi:nil="true"/&gt; &lt;Free16 xsi:nil="true"/&gt; &lt;Free17 xsi:nil="true"/&gt; &lt;Free18 xsi:nil="true"/&gt; &lt;Free19 xsi:nil="true"/&gt; &lt;Free20 xsi:nil="true"/&gt; &lt;/FreeTextFields&gt; &lt;Texts xsi:type="ns1:PlentySoapObject_ItemTexts"&gt; &lt;Lang xsi:type="xsd:string"&gt;de&lt;/Lang&gt; &lt;Name xsi:type="xsd:string"&gt;Star Wars: The Force Unleashed 1 - Xbox 360&lt;/Name&gt; &lt;Name2 xsi:type="xsd:string"/&gt; &lt;Name3 xsi:type="xsd:string"/&gt; &lt;ShortDescription xsi:nil="true"/&gt; &lt;LongDescription xsi:nil="true"/&gt; &lt;TechnicalData xsi:nil="true"/&gt; &lt;MetaDescription xsi:nil="true"/&gt; &lt;Keywords xsi:type="xsd:string"/&gt; &lt;/Texts&gt; &lt;PriceSet xsi:type="ns1:PlentySoapObject_ItemPriceSet"&gt; &lt;PriceID xsi:type="xsd:int"&gt;2&lt;/PriceID&gt; &lt;Lot xsi:type="xsd:float"&gt;0&lt;/Lot&gt; &lt;Unit xsi:type="xsd:string"&gt;C62&lt;/Unit&gt; &lt;Unit1 xsi:type="xsd:string"/&gt; &lt;Unit2 xsi:type="xsd:string"/&gt; &lt;PackagingUnit xsi:type="xsd:string"&gt;1&lt;/PackagingUnit&gt; &lt;Price xsi:type="xsd:float"&gt;20.99&lt;/Price&gt; &lt;Price1 xsi:type="xsd:float"&gt;18.65&lt;/Price1&gt; &lt;Price2 xsi:type="xsd:float"&gt;23.99&lt;/Price2&gt; &lt;Price3 xsi:type="xsd:float"&gt;999&lt;/Price3&gt; &lt;Price4 xsi:type="xsd:float"&gt;999&lt;/Price4&gt; &lt;Price5 xsi:type="xsd:float"&gt;0&lt;/Price5&gt; &lt;Price6 xsi:type="xsd:float"&gt;0&lt;/Price6&gt; &lt;Price7 xsi:type="xsd:float"&gt;0&lt;/Price7&gt; &lt;Price8 xsi:type="xsd:float"&gt;0&lt;/Price8&gt; &lt;Price9 xsi:type="xsd:float"&gt;0&lt;/Price9&gt; &lt;Price10 xsi:type="xsd:float"&gt;0&lt;/Price10&gt; &lt;Price11 xsi:type="xsd:float"&gt;23.7&lt;/Price11&gt; &lt;Price12 xsi:type="xsd:float"&gt;33.7&lt;/Price12&gt; &lt;RRP xsi:type="xsd:float"&gt;0&lt;/RRP&gt; &lt;VAT xsi:type="xsd:float"&gt;19&lt;/VAT&gt; &lt;WeightInGramm xsi:type="xsd:int"&gt;0&lt;/WeightInGramm&gt; &lt;WidthInMM xsi:type="xsd:int"&gt;0&lt;/WidthInMM&gt; &lt;LengthInMM xsi:type="xsd:int"&gt;0&lt;/LengthInMM&gt; &lt;HeightInMM xsi:type="xsd:int"&gt;0&lt;/HeightInMM&gt; &lt;Position xsi:type="xsd:int"&gt;0&lt;/Position&gt; &lt;ShowOnly xsi:type="xsd:int"&gt;0&lt;/ShowOnly&gt; &lt;RebateLevelPrice6 xsi:type="xsd:int"&gt;0&lt;/RebateLevelPrice6&gt; &lt;RebateLevelPrice7 xsi:type="xsd:int"&gt;0&lt;/RebateLevelPrice7&gt; &lt;RebateLevelPrice8 xsi:type="xsd:int"&gt;0&lt;/RebateLevelPrice8&gt; &lt;PurchasePriceNet xsi:type="xsd:float"&gt;14.38&lt;/PurchasePriceNet&gt; &lt;Package xsi:type="xsd:int"&gt;0&lt;/Package&gt; &lt;TypeOfPackage xsi:type="xsd:int"&gt;0&lt;/TypeOfPackage&gt; &lt;UnitLoadDevice xsi:type="xsd:int"&gt;0&lt;/UnitLoadDevice&gt; &lt;/PriceSet&gt; &lt;Stock xsi:type="ns1:PlentySoapObject_ItemStock"&gt; &lt;Limitation xsi:type="xsd:int"&gt;1&lt;/Limitation&gt; &lt;MainWarehouseID xsi:type="xsd:int"&gt;2&lt;/MainWarehouseID&gt; &lt;WebshopVisiblePositiveStock xsi:type="xsd:boolean"&gt;false&lt;/WebshopVisiblePositiveStock&gt; &lt;WebshopInvisibleNoStock xsi:type="xsd:boolean"&gt;false&lt;/WebshopInvisibleNoStock&gt; &lt;ChangeAvailablePositiveStock xsi:type="xsd:boolean"&gt;true&lt;/ChangeAvailablePositiveStock&gt; &lt;ChangeNotAvailableNoStock xsi:type="xsd:boolean"&gt;true&lt;/ChangeNotAvailableNoStock&gt; &lt;ChangeAvailablePositiveStockVariant xsi:type="xsd:boolean"&gt;false&lt;/ChangeAvailablePositiveStockVariant&gt; &lt;ChangeNotAvailableNoStockVariant xsi:type="xsd:boolean"&gt;false&lt;/ChangeNotAvailableNoStockVariant&gt; &lt;StorageLocation xsi:nil="true"/&gt; &lt;/Stock&gt; &lt;Availability xsi:type="ns1:PlentySoapObject_ItemAvailability"&gt; &lt;AvailabilityID xsi:type="xsd:int"&gt;5&lt;/AvailabilityID&gt; &lt;Webshop xsi:type="xsd:int"&gt;1&lt;/Webshop&gt; &lt;WebAPI xsi:type="xsd:int"&gt;1&lt;/WebAPI&gt; &lt;Inactive xsi:type="xsd:int"&gt;0&lt;/Inactive&gt; &lt;AmazonFBA xsi:type="xsd:int"&gt;1&lt;/AmazonFBA&gt; &lt;AmazonFEDAS xsi:type="xsd:string"/&gt; &lt;AmazonProduct xsi:type="xsd:int"&gt;31&lt;/AmazonProduct&gt; &lt;Gimahhot xsi:type="xsd:int"&gt;0&lt;/Gimahhot&gt; &lt;GoogleBase xsi:type="xsd:int"&gt;0&lt;/GoogleBase&gt; &lt;Hitmeister xsi:type="xsd:int"&gt;0&lt;/Hitmeister&gt; &lt;MeinPaket xsi:type="xsd:int"&gt;0&lt;/MeinPaket&gt; &lt;Mercateo xsi:type="xsd:int"&gt;0&lt;/Mercateo&gt; &lt;Quelle xsi:type="xsd:int"&gt;0&lt;/Quelle&gt; &lt;Moebelprofi xsi:type="xsd:int"&gt;0&lt;/Moebelprofi&gt; &lt;Zalando xsi:type="xsd:int"&gt;0&lt;/Zalando&gt; &lt;Restposten xsi:type="xsd:int"&gt;0&lt;/Restposten&gt; &lt;Shopgate xsi:type="xsd:int"&gt;0&lt;/Shopgate&gt; &lt;Shopperella xsi:type="xsd:int"&gt;0&lt;/Shopperella&gt; &lt;ShopShare xsi:type="xsd:int"&gt;0&lt;/ShopShare&gt; &lt;Tradoria xsi:type="xsd:int"&gt;0&lt;/Tradoria&gt; &lt;TradoriaCategory xsi:type="xsd:int"&gt;0&lt;/TradoriaCategory&gt; &lt;Yatego xsi:type="xsd:int"&gt;0&lt;/Yatego&gt; &lt;AvailableUntil xsi:type="xsd:int"&gt;0&lt;/AvailableUntil&gt; &lt;MaximumSalesOrderQuantity xsi:type="xsd:int"&gt;0&lt;/MaximumSalesOrderQuantity&gt; &lt;Neckermann xsi:type="xsd:int"&gt;0&lt;/Neckermann&gt; &lt;/Availability&gt; &lt;Others xsi:nil="true"/&gt; &lt;Categories xsi:nil="true"/&gt; &lt;AttributeValueSets xsi:nil="true"/&gt; &lt;ItemSuppliers xsi:nil="true"/&gt; &lt;ItemProperties xsi:nil="true"/&gt; &lt;ItemAttributeMarkup xsi:nil="true"/&gt; &lt;BundleType xsi:nil="true"/&gt; &lt;DeepLink xsi:type="xsd:string"&gt;/a-2/&lt;/DeepLink&gt; &lt;/item&gt; </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USK213
    1. USK213
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POLinq to XML C# Descendants: How to read Attributes with the same name?
      1. USsantosh singh
      1. VTFavorite
    2. VO
      singulars
      1. POLinq to XML C# Descendants: How to read Attributes with the same name?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COWhat is the content of `readString` variable?
      singulars
      1. POLinq to XML C# Descendants: How to read Attributes with the same name?
      1. USIvan G
    2. COstring readString = send_recv(document);
      singulars
      1. POLinq to XML C# Descendants: How to read Attributes with the same name?
      1. USK213
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload