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 "address"
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 :
<?xml version="1.0" encoding="UTF-8"?>
<bridge xmlns="[url]http://CTL.COM.SERVICES.BRIDGE.DataEntities">[/URL]
<applications>
<application createdBy="CTL Card Tech Services Ltd(Cyprus)">
<customer number="368266 " templateCode="CCU1 " name="Khoury">
<addresses>
<address title="MLE" country=" " city=" " state=" " zip=" " address2="AL BIARA " address1="GERANIUM " firstName="NADA " lastName="KHOURY " location=" " addressType="TT "/></addresses>
</customer>
</application>
<people id=" "/></applications></bridge>
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 "address"
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 :
<?xml version="1.0" encoding="UTF-8"?>
<bridge xmlns="[url]http://CTL.COM.SERVICES.BRIDGE.DataEntities">[/URL]
<applications>
<application createdBy="CTL Card Tech Services Ltd(Cyprus)">
<customer number="368266 " templateCode="CCU1 " name="Khoury">
<addresses>
<address title="MLE" country=" " city=" " state=" " zip=" " address2="AL BIARA " address1="GERANIUM " firstName="NADA " lastName="KHOURY " location=" " addressType="TT "/></addresses>
</customer>
</application>
<people id=" "/></applications></bridge>
