Reply to thread

Message

<blockquote data-quote="nadakhou" data-source="post: 180182" data-attributes="member: 55033">Dear Sir,I am reading from a databse to fill an xml file,here is the code and the resultsmy problem is that i am not beeing able to close the element &quot;address&quot; what is missing in my code?any help? thanks in advance&nbsp;&nbsp; ' Loop over employees in array.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; For Each dataRow1 As DataRow In dt1.Rows&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; writer.WriteStartElement(&quot;applications&quot;)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; writer.WriteStartElement(&quot;application&quot;)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; writer.WriteAttributeString(&quot;createdBy&quot;, &quot;CTL Card Tech Services Ltd(Cyprus)&quot;)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; writer.WriteStartElement(&quot;customer&quot;)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; writer.WriteAttributeString(&quot;name&quot;, dataRow1(&quot;GNP27NAM&quot;))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; writer.WriteAttributeString(&quot;templateCode&quot;, dataRow1(&quot;GNP27TCD&quot;))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; writer.WriteAttributeString(&quot;number&quot;, dataRow1(&quot;GNP27CUI&quot;))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; writer.WriteStartElement(&quot;addresses&quot;)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; writer.WriteStartElement(&quot;address&quot;)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; writer.WriteAttributeString(&quot;addressType&quot;, dataRow1(&quot;GNP27ATP&quot;))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; writer.WriteAttributeString(&quot;location&quot;, dataRow1(&quot;GNP27LOC&quot;))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; writer.WriteAttributeString(&quot;lastName&quot;, dataRow1(&quot;GNP27LNM&quot;))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; writer.WriteAttributeString(&quot;firstName&quot;, dataRow1(&quot;GNP27FNM&quot;))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; writer.WriteAttributeString(&quot;address1&quot;, dataRow1(&quot;GNP27AD1&quot;))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; writer.WriteAttributeString(&quot;address2&quot;, dataRow1(&quot;GNP27AD2&quot;))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; writer.WriteAttributeString(&quot;zip&quot;, dataRow1(&quot;GNP27ZIP&quot;))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; writer.WriteAttributeString(&quot;state&quot;, dataRow1(&quot;GNP27STT&quot;))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; writer.WriteAttributeString(&quot;city&quot;, dataRow1(&quot;GNP27CTY&quot;))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; writer.WriteAttributeString(&quot;country&quot;, dataRow1(&quot;GNP27CNT&quot;))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; writer.WriteAttributeString(&quot;title&quot;, dataRow1(&quot;GNP27TTL&quot;))Next&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; writer.WriteEndElement()&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; writer.WriteEndDocument()xml result :&lt;?xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot;?&gt;<a href="http://file:///C:/Users/NKHOURY/Documents/Cards_Bridge.xml#">&lt;bridge xmlns=&quot;[url]http://CTL.COM.SERVICES.BRIDGE.DataEntities</a>&quot;&gt;[/URL]<a href="http://file:///C:/Users/NKHOURY/Documents/Cards_Bridge.xml#">&lt;applications&gt;</a><a href="http://file:///C:/Users/NKHOURY/Documents/Cards_Bridge.xml#">&lt;application createdBy=&quot;CTL Card Tech Services Ltd(Cyprus)&quot;&gt;</a><a href="http://file:///C:/Users/NKHOURY/Documents/Cards_Bridge.xml#">&lt;customer number=&quot;368266&nbsp; &nbsp; &quot; templateCode=&quot;CCU1&nbsp; &nbsp; &quot; name=&quot;Khoury&quot;&gt;</a><a href="http://file:///C:/Users/NKHOURY/Documents/Cards_Bridge.xml#">&lt;addresses&gt;</a>&lt;address title=&quot;MLE&quot; country=&quot;&nbsp;&nbsp; &quot; city=&quot;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &quot; state=&quot;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &quot; zip=&quot;&nbsp; &nbsp;&nbsp; &quot; address2=&quot;AL BIARA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &quot; address1=&quot;GERANIUM&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &quot; firstName=&quot;NADA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &quot; lastName=&quot;KHOURY&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &quot; location=&quot;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &quot; addressType=&quot;TT&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &quot;/&gt;&lt;/addresses&gt;&lt;/customer&gt;&lt;/application&gt;&lt;people id=&quot; &quot;/&gt;&lt;/applications&gt;&lt;/bridge&gt;</blockquote>

[QUOTE="nadakhou, post: 180182, member: 55033"] Dear Sir, I am reading from a databse to fill an xml file,here is the code and the results my problem is that i am not beeing able to close the element "[COLOR=#990000]address"[/COLOR][COLOR=#0000ff] [/COLOR][COLOR=#990000][/COLOR] what is missing in my code?any help? thanks in advance ' Loop over employees in array. For Each dataRow1 As DataRow In dt1.Rows writer.WriteStartElement("applications") writer.WriteStartElement("application") writer.WriteAttributeString("createdBy", "CTL Card Tech Services Ltd(Cyprus)") writer.WriteStartElement("customer") writer.WriteAttributeString("name", dataRow1("GNP27NAM")) writer.WriteAttributeString("templateCode", dataRow1("GNP27TCD")) writer.WriteAttributeString("number", dataRow1("GNP27CUI")) writer.WriteStartElement("addresses") writer.WriteStartElement("address") writer.WriteAttributeString("addressType", dataRow1("GNP27ATP")) writer.WriteAttributeString("location", dataRow1("GNP27LOC")) writer.WriteAttributeString("lastName", dataRow1("GNP27LNM")) writer.WriteAttributeString("firstName", dataRow1("GNP27FNM")) writer.WriteAttributeString("address1", dataRow1("GNP27AD1")) writer.WriteAttributeString("address2", dataRow1("GNP27AD2")) writer.WriteAttributeString("zip", dataRow1("GNP27ZIP")) writer.WriteAttributeString("state", dataRow1("GNP27STT")) writer.WriteAttributeString("city", dataRow1("GNP27CTY")) writer.WriteAttributeString("country", dataRow1("GNP27CNT")) writer.WriteAttributeString("title", dataRow1("GNP27TTL")) Next writer.WriteEndElement() writer.WriteEndDocument() xml result : [COLOR=blue]<?xml version="1.0" encoding="UTF-8"?>[/COLOR] [URL="file:///C:/Users/NKHOURY/Documents/Cards_Bridge.xml#"]<[COLOR=#990000]bridge[/COLOR] [COLOR=red]xmlns[/COLOR]="[COLOR=red][B][url]http://CTL.COM.SERVICES.BRIDGE.DataEntities[/B][/COLOR][/url][COLOR=red][B][/B][/COLOR]">[/URL] [URL="file:///C:/Users/NKHOURY/Documents/Cards_Bridge.xml#"]<[COLOR=#990000]applications[/COLOR]>[/URL] [URL="file:///C:/Users/NKHOURY/Documents/Cards_Bridge.xml#"]<[COLOR=#990000]application[/COLOR] [COLOR=#990000]createdBy[/COLOR]="[COLOR=black][B]CTL Card Tech Services Ltd(Cyprus)[/B][/COLOR]">[/URL] [URL="file:///C:/Users/NKHOURY/Documents/Cards_Bridge.xml#"]<[COLOR=#990000]customer[/COLOR] [COLOR=#990000]number[/COLOR]="[COLOR=black][B]368266 [/B][/COLOR]" [COLOR=#990000]templateCode[/COLOR]="[COLOR=black][B]CCU1 [/B][/COLOR]" [COLOR=#990000]name[/COLOR]="[COLOR=black][B]Khoury[/B][/COLOR]">[/URL] [URL="file:///C:/Users/NKHOURY/Documents/Cards_Bridge.xml#"]<[COLOR=#990000]addresses[/COLOR]>[/URL] <[COLOR=#990000]address[/COLOR] [COLOR=#990000]title[/COLOR]="[COLOR=black][B]MLE[/B][/COLOR]" [COLOR=#990000]country[/COLOR]="[COLOR=black][B] [/B][/COLOR]" [COLOR=#990000]city[/COLOR]="[COLOR=black][B] [/B][/COLOR]" [COLOR=#990000]state[/COLOR]="[COLOR=black][B] [/B][/COLOR]" [COLOR=#990000]zip[/COLOR]="[COLOR=black][B] [/B][/COLOR]" [COLOR=#990000]address2[/COLOR]="[COLOR=black][B]AL BIARA [/B][/COLOR]" [COLOR=#990000]address1[/COLOR]="[COLOR=black][B]GERANIUM [/B][/COLOR]" [COLOR=#990000]firstName[/COLOR]="[COLOR=black][B]NADA [/B][/COLOR]" [COLOR=#990000]lastName[/COLOR]="[COLOR=black][B]KHOURY [/B][/COLOR]" [COLOR=#990000]location[/COLOR]="[COLOR=black][B] [/B][/COLOR]" [COLOR=#990000]addressType[/COLOR]="[COLOR=black][B]TT [/B][/COLOR]"/>[COLOR=blue]</[COLOR=#990000]addresses[/COLOR]>[/COLOR] [COLOR=blue]</[COLOR=#990000]customer[/COLOR]>[/COLOR] [COLOR=blue]</[COLOR=#990000]application[/COLOR]>[/COLOR] <[COLOR=#990000]people[/COLOR] [COLOR=#990000]id[/COLOR]="[COLOR=black][B] [/B][/COLOR]"/>[COLOR=blue]</[COLOR=#990000]applications[/COLOR]>[/COLOR][COLOR=blue]</[COLOR=#990000]bridge[/COLOR]>[/COLOR] [/QUOTE]

Verification