DataSet\XMLWrite

I am using ASP.NET v1.1.432. We have an admin site, where the user can
create a xml file for GoogleMaps from the database. We are using
ds.WriteXML("C:\data.xml) Below is some of the output from this.
<NewDataSet>
-<COMPANY>
<LAT>29.422076</LAT>
<LON>-98.464062</LON>
<ORG>3M</ORG>
<AD>3M Center</AD>
<CITY>St Paul</CITY>
<ST>MN</ST>
<ZIP>55144</ZIP>
<ID>27164</ID>
<WEB>www.3m.com/construction</WEB>
</COMPANY>
-<COMPANY>
<LAT>39.785092</LAT>
<LON>-86.129945</LON>
<ORG>4D Engineering</ORG>
<AD>201 1658 Commerce Ave</AD>
<CITY>Kelowna</CITY>
<ST>BC</ST>
<ZIP>V1X 8A9</ZIP>
<ID>9171</ID>
<WEB>www.4deng.com</WEB>
</COMPANY>
......
</NewDataSet>

This is how the file is currently being generated by another xml tool
and the way we need it to be done. Is there a component that has
properties we can set to generate the xml like below or another way?

Thanks

<markers>
<marker lat="49.89338" lng="-119.419564" org="4D Engineering"
tel="250-762-6488" cat="191" ad="#201-1658 Commerce Ave" city="Kelowna"
st="BC" zip="V1X 8A9" id="2534" eml="ke*****@4deng.com"
web="www.4deng.com"/>
<marker lat="-10.9106" lng="-37.059898" org="554 Red Horse Squadron"
tel="671-366-6195" cat="189" ad="Unit #14014" city="APO" st="AP"
zip="96543" id="3341"/>
<marker lat="30.3766" lng="-97.9557" org="A Greater Austin Development
Co Ltd" tel="512-310-9300" cat="193" ad="PO Box 342587" city="Auston"
st="TX" zip="78734" id="3415" web="www.agadco.com"/>
</markers>

Jul 11 '08 #1

Subscribe Post Reply

1290

sloan

This blog entry may help you with an xml to xml conversion.

http://sholliday.spaces.live.com/Blog/cns!A68482B9628A842A!148.entry

A dataset at its core is just a fancied up xml document.

Report back if it helps please.

"gh" <gh@att.netwrote in message
news:%2***************@TK2MSFTNGP06.phx.gbl...

>I am using ASP.NET v1.1.432. We have an admin site, where the user can
create a xml file for GoogleMaps from the database. We are using
ds.WriteXML("C:\data.xml) Below is some of the output from this.
<NewDataSet>
-<COMPANY>
<LAT>29.422076</LAT>
<LON>-98.464062</LON>
<ORG>3M</ORG>
<AD>3M Center</AD>
<CITY>St Paul</CITY>
<ST>MN</ST>
<ZIP>55144</ZIP>
<ID>27164</ID>
<WEB>www.3m.com/construction</WEB>
</COMPANY>
-<COMPANY>
<LAT>39.785092</LAT>
<LON>-86.129945</LON>
<ORG>4D Engineering</ORG>
<AD>201 1658 Commerce Ave</AD>
<CITY>Kelowna</CITY>
<ST>BC</ST>
<ZIP>V1X 8A9</ZIP>
<ID>9171</ID>
<WEB>www.4deng.com</WEB>
</COMPANY>
.....
</NewDataSet>

This is how the file is currently being generated by another xml tool and
the way we need it to be done. Is there a component that has properties
we can set to generate the xml like below or another way?

Thanks

<markers>
<marker lat="49.89338" lng="-119.419564" org="4D Engineering"
tel="250-762-6488" cat="191" ad="#201-1658 Commerce Ave" city="Kelowna"
st="BC" zip="V1X 8A9" id="2534" eml="ke*****@4deng.com"
web="www.4deng.com"/>
<marker lat="-10.9106" lng="-37.059898" org="554 Red Horse Squadron"
tel="671-366-6195" cat="189" ad="Unit #14014" city="APO" st="AP"
zip="96543" id="3341"/>
<marker lat="30.3766" lng="-97.9557" org="A Greater Austin Development Co
Ltd" tel="512-310-9300" cat="193" ad="PO Box 342587" city="Auston" st="TX"
zip="78734" id="3415" web="www.agadco.com"/>
</markers>

Jul 11 '08 #2