i very rarely have the need to use XML, but in this case i have to generate an xml file based on an xsd provided by an external company.
i can create the xml file fine apart from the address part which seems to be grouped. it is the UK standard for address layouts in xml (i think)
Does anyone know how this can be achieved when my data is not structured this way. ie a have a dataset with a single datatable with Address1, Adress2 etc. Is there a simple way to convert this to the required layout above.
Any help greatly appreciated.
i can create the xml file fine apart from the address part which seems to be grouped. it is the UK standard for address layouts in xml (i think)
HTML:
<A_5LineAddress>
<apd:Line>a</apd:Line>
<apd:Line>a</apd:Line>
<apd:Line>a</apd:Line>
<apd:Line>a</apd:Line>
<apd:PostCode>A00 0AA</apd:PostCode>
<PostCode>A00 0AA</PostCode>
</A_5LineAddress>
Does anyone know how this can be achieved when my data is not structured this way. ie a have a dataset with a single datatable with Address1, Adress2 etc. Is there a simple way to convert this to the required layout above.
Any help greatly appreciated.