Hallo
ich habe nun schon so einiges versucht nun muss ich mal fragen ??
nicht schlagen wenn ich hier aufm holz weg bin.
die xml ist noch um einiges länger habe nur mal den wichtigen teil herausgenommen
Ich möchte gern ab assembly die xml durchlaufen und alle mainpart num und quantity uns alle singelpart num und quantity im datagritview angezeigt bekommen ......da kommen auch noch werte dazu die ich auch noch benötige
im mom bekomm ich immer nur die erste mainpart num angezeigt
irgend etwas haut da mit der schleife nicht hin
mfg homes22
ich habe nun schon so einiges versucht nun muss ich mal fragen ??
nicht schlagen wenn ich hier aufm holz weg bin.
die xml ist noch um einiges länger habe nur mal den wichtigen teil herausgenommen
XML-Quellcode
- <modelExtract>
- <header>
- <modelFilename>C:\Users\xxxxxx</modelFilename>
- <modelUnits>
- <length unit="3" precision="2" representation="3"/>
- <area unit="3005" precision="203" representation="3003"/>
- <angle unit="2006" precision="80" representation="2006"/>
- <weight unit="1002" precision="112" representation="1009"/>
- </modelUnits>
- <extractUnits>
- <length unit="3" precision="4" representation="3"/>
- <area unit="-1" precision="-1" representation="-1"/>
- <angle unit="2006" precision="84" representation="2006"/>
- <weight unit="1009" precision="112" representation="1009"/>
- </extractUnits>
- <project>
- <name>xxxxxx</name>
- <number>192_2015</number>
- <client>xxxxx</client>
- <buildingLocation>xxxxx</buildingLocation>
- <contractor>xxxxx</contractor>
- <dateOrder>08.05.2015</dateOrder>
- <designer>xxxxx</designer>
- <dateConstruction>08.05.2015</dateConstruction>
- <detailer>xxxxxx</detailer>
- </project>
- <extractId>MyModel.ModelExtracts.Key</extractId>
- <updateIndex id="MyModel.ModelExtracts.State"/>
- </header>
- <parts>
- <assembly name="Tor Achse O">
- <mainpart id="819B0" num="20" quantity="1">
- <explicitQuantity>1</explicitQuantity>
- <proxy id="8192A" ACADID="8192B" basepart="26B8F">
- <assemblyWeight>3950.36</assemblyWeight>
- <assemblyExactWeight>3898.36</assemblyExactWeight>
- <collisionSize x="218.000" y="130.250" z="86.246"/>
- <singlepart id="82363" num="20" quantity="1">
- <explicitQuantity>1</explicitQuantity>
- <part id="26B8F" name="BL15x218x85" class="Plate" ACADID="16DD8" dstvName="BL 15">
- <explicitQuantity>1</explicitQuantity>
- <role key="T-plate" name="T-Bleche"/>
- <length>218.000</length>
- <paintArea>46148.247</paintArea>
- <numHoles>2</numHoles>
- <material key="S235JR" name="S235JR"/>
- <weight>2181.81</weight>
- <exactWeight>2127.85</exactWeight>
- <thickness>15.000</thickness>
- <width>84.996</width>
- <area1>18529.180</area1>
- <area2>18529.180</area2>
- <contourLength>605.992</contourLength>
- <ElementID>6229</ElementID>
- </part>
- </singlepart>
- <singlepart id="8235F" num="1047" quantity="1">
- <explicitQuantity>1</explicitQuantity>
- <part id="26B88" name="BL10x204x115.3" class="Plate" ACADID="16DDA" dstvName="BL 10">
- <explicitQuantity>1</explicitQuantity>
- <role key="Stiffener#1" name="Steife"/>
- <length>204.000</length>
- <paintArea>51228.903</paintArea>
- <material key="S235JR" name="S235JR"/>
- <weight>1768.55</weight>
- <exactWeight>1770.51</exactWeight>
- <thickness>10.000</thickness>
- <width>115.250</width>
- <area1>22529.252</area1>
- <area2>22529.252</area2>
- <contourLength>617.040</contourLength>
- <ElementID>6230</ElementID>
- </part>
- </singlepart>
- </proxy>
- </mainpart>
- <mainpart id="819A5" num="9" quantity="1">
- <explicitQuantity>1</explicitQuantity>
- <proxy id="8192C" ACADID="8192D" basepart="7ECC8">
- <assemblyWeight>93393.09</assemblyWeight>
- <assemblyExactWeight>93233.65</assemblyExactWeight>
- <collisionSize x="2692.682" y="240.000" z="85.000"/>
- <singlepart id="819B6" num="9" quantity="1">
- <explicitQuantity>1</explicitQuantity>
- <part id="7ECC8" name="U240" class="Beam" ACADID="7ECC9" dstvName="U240">
- <explicitQuantity>1</explicitQuantity>
- <externalName name="U240" index="1"/>
- <length>2657.000</length>
- <paintArea>2059174.743</paintArea>
- <material key="S235JR" name="S235JR"/>
- <weight>88212.39</weight>
- <exactWeight>88214.40</exactWeight>
- <weightPerMeter>33200.00</weightPerMeter>
- <section key="Channels DIN18800-1#@§@#U240" name="U240"/>
- <sysLength>2657.000</sysLength>
- <sawLength>2657.000</sawLength>
- <angleX1>0.0000</angleX1>
- <angleY1>0.0000</angleY1>
- <angleX2>0.0000</angleX2>
- <angleY2>0.0000</angleY2>
- <SawCutInfo>0</SawCutInfo>
- <ElementID>24321</ElementID>
- </part>
- </singlepart>
- <singlepart id="81984" num="1009" quantity="1">
- <explicitQuantity>1</explicitQuantity>
- <part id="802CC" name="BL20x230x80" class="Plate" ACADID="802B8" dstvName="BL 20">
- <explicitQuantity>1</explicitQuantity>
- <role key="Endplate#1" name="Kopfplatte"/>
- <denotation>USP</denotation>
- <externalName name="FL80X20" index="1"/>
- <length>230.000</length>
- <paintArea>49199.995</paintArea>
- <numHoles>2</numHoles>
- <material key="S235JR" name="S235JR"/>
- <weight>2888.80</weight>
- <exactWeight>2781.32</exactWeight>
- <thickness>20.000</thickness>
- <width>80.000</width>
- <area1>18399.998</area1>
- <area2>18399.998</area2>
- <contourLength>620.000</contourLength>
- <ElementID>24524</ElementID>
- </part>
- </singlepart>
- <singlepart id="82411" num="1049" quantity="1">
- <explicitQuantity>1</explicitQuantity>
- <part id="26B97" name="BL15x229x85" class="Plate" ACADID="16DD6" dstvName="BL 15">
- <explicitQuantity>1</explicitQuantity>
- <role key="Endplate#1" name="Kopfplatte"/>
- <length>229.000</length>
- <paintArea>48348.164</paintArea>
- <numHoles>2</numHoles>
- <material key="S235JR" name="S235JR"/>
- <weight>2291.90</weight>
- <exactWeight>2237.94</exactWeight>
- <thickness>15.000</thickness>
- <width>84.996</width>
- <area1>19464.138</area1>
- <area2>19464.138</area2>
- <contourLength>627.992</contourLength>
- <ElementID>6228</ElementID>
- </part>
- </singlepart>
- </proxy>
- <boltPatternOnSite id="7ED44" num="1032" name="EN 14399-4-M16X60Mu2S-10.9-TZN" class="BoltPattern" ACADID="7ED45" setkey="1" nameBolt="Sechskantschraube EN 14399-4 16 x 60 - 10.9 HV" setBoltsType="1">
- <explicitQuantity>1</explicitQuantity>
- <set key="Mu2S" name="Mu2S"/>
- <numBolts>2</numBolts>
- <standard key="14399-4" name="EN 14399-4"/>
- <diameter>16.000</diameter>
- <material key="10.9" name="10.9"/>
- <coating key="TZN" name="TZN"/>
- <boltLength>60.000</boltLength>
- <fitLength>32.000</fitLength>
- <fitLengthIncrement>0.000</fitLengthIncrement>
- <holeTolerance>2.000</holeTolerance>
- <mountLocation>0</mountLocation>
- <ConnectedPartsIds>82411,8192C;82363,8192A;</ConnectedPartsIds>
- </boltPatternOnSite>
- <boltPatternOnSite id="802D0" num="1030" name="EN 14399-4-M20X75Mu2S-10.9-TZN" class="BoltPattern" ACADID="802BA" setkey="2" nameBolt="Sechskantschraube EN 14399-4 20 x 75 - 10.9 HV" setBoltsType="1">
- <explicitQuantity>1</explicitQuantity>
- <set key="Mu2S" name="Mu2S"/>
- <numBolts>2</numBolts>
- <standard key="14399-4" name="EN 14399-4"/>
- <diameter>20.000</diameter>
- <material key="10.9" name="10.9"/>
- <coating key="TZN" name="TZN"/>
- <boltLength>75.000</boltLength>
- <fitLength>40.002</fitLength>
- <fitLengthIncrement>0.000</fitLengthIncrement>
- <holeTolerance>2.000</holeTolerance>
- <mountLocation>0</mountLocation>
- <ConnectedPartsIds>81984,8192C;81982,8194A;</ConnectedPartsIds>
- </boltPatternOnSite>
- </mainpart>
- </assembly>
- <assembly name="Bestand"/>
- </parts>
- <DerivedDocuments>
- <Details/>
- <BOMs/>
- <DSTVFiles/>
- </DerivedDocuments>
- </modelExtract>
VB.NET-Quellcode
- Imports System.Xml
- Imports System.Data
- Public Class Form1
- Private Sub Button2_Click_1(sender As Object, e As EventArgs) Handles Button1.Click, Button2.Click
- doc.Load("d:\MySchema.xml")
- Dim header As XmlNodeList = doc.DocumentElement.SelectNodes("/modelExtract")
- Dim assemply As XmlNodeList = doc.DocumentElement.SelectNodes("/modelExtract/parts")
- Dim xr As Xml.XmlTextReader = New Xml.XmlTextReader("d:\MySchema.xml")
- Dim projekt_name As String = "", projekt_number As String = "", projekt_client As String = "", buildingLocation As String = "", contractor As String = "", dateOrder As String = "", designer As String = "", dateConstruction As String = "", detailer As String = ""
- Dim assemplyname As String = "", mainpartnum As String = "", mainpartq As String = ""
- For Each node As XmlNode In header
- 'ListBox1.Items.Clear()
- projekt_name = node.SelectSingleNode("header/project/name").InnerText
- projekt_number = node.SelectSingleNode("header/project/number").InnerText
- projekt_client = node.SelectSingleNode("header/project/client").InnerText
- buildingLocation = node.SelectSingleNode("header/project/buildingLocation").InnerText
- contractor = node.SelectSingleNode("header/project/contractor").InnerText
- dateOrder = node.SelectSingleNode("header/project/dateOrder").InnerText
- designer = node.SelectSingleNode("header/project/designer").InnerText
- dateConstruction = node.SelectSingleNode("header/project/dateConstruction").InnerText
- detailer = node.SelectSingleNode("header/project/detailer").InnerText
- 'header
- i = 0
- Do While xr.Read
- If xr.NodeType = Xml.XmlNodeType.Element Then
- If (xr.Name = "parts") Then
- If xr.NodeType = Xml.XmlNodeType.Element Then
- For Each noden As XmlNode In assemply
- assemplyname = noden.SelectSingleNode("assembly/@name").InnerText
- Next
- If (xr.Name = "parts") Then
- For Each nodem As XmlNode In assemply
- mainpartnum = nodem.SelectSingleNode("assembly/mainpart/@num").InnerText
- mainpartq = nodem.SelectSingleNode("assembly/mainpart/@quantity").InnerText
- Next
- End If
- End if
- End If
- End If
- Loop
- DataGridView1.Rows.Clear()
- DataGridView1.ColumnCount = 9
- DataGridView1.Rows.Add(projekt_name, projekt_number, projekt_client, buildingLocation, contractor, dateOrder, designer, dateConstruction, detailer)
- DataGridView1.Rows.Add(assemplyname, mainpartnum, mainpartq)
- Next
- End Sub
Ich möchte gern ab assembly die xml durchlaufen und alle mainpart num und quantity uns alle singelpart num und quantity im datagritview angezeigt bekommen ......da kommen auch noch werte dazu die ich auch noch benötige
im mom bekomm ich immer nur die erste mainpart num angezeigt
irgend etwas haut da mit der schleife nicht hin
mfg homes22
Dieser Beitrag wurde bereits 2 mal editiert, zuletzt von „homes22“ ()