DataSet\XMLWrite

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • gh
    #1

    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.42207 6</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.c om/construction</WEB>
    </COMPANY>
    -<COMPANY>
    <LAT>39.78509 2</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="kelowna@4d eng.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>
    Tags: None
    • sloan
      #2
      Re: DataSet\XMLWrit e

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

      http://sholliday.space s.live.com/Blog/cns!A68482B9628 A842A!148.entry

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

      Report back if it helps please.




      "gh" <gh@att.netwrot e in message
      news:%23d0suI34 IHA.408@TK2MSFT NGP06.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.42207 6</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.c om/construction</WEB>
      </COMPANY>
      -<COMPANY>
      <LAT>39.78509 2</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="kelowna@4d eng.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>

        Comment

        Previous template Next
        Working...