Need help to format an XML file, from Dataset

• • Reply

  14 years ago

  by Vayse

  Diarmuid Net

  , Ireland

  Joined 14 years ago
  Hi
  This is an area I've not looked at before, and I don't know where to start.
  I've created an XML file using the following code:
  
  Dim dsCase As New Bookings.qryXML_OutDataTable
  dsCase = Me.Bookings.qryXML_Out
  dsCase.WriteXml(Me.txtXMLPath.Text)
  
  
  qryXML_Out is a query in an Access database. The XML file looks like:
  
  <?xml version="1.0" standalone="yes" ?>
  - <ERP_TO_WPA xmlns="http://tempuri.org/Bookings.xsd">
  - <qryXML_Out>
    <ActivateNow>1</ActivateNow>
  other fields here
  <Status>1</Status>
    </qryXML_Out>
    </ERP_TO_WPA>
  
  Now the data is fine. But this XML file is going to another application, and
  it requires a different start and end. As shown here
  <?xml version="1.0" encoding="ISO-8859-1"?>
  <ERP_TO_WPA>
  <Case>
  <ActivateNow>1</ActivateNow>
  
  Status>1</Status>
  </Case>
  <Item>
  </Item>
  </ERP_TO_WPA>
  
  So my questions are:
  1) How do I change from Standalone = "yes" to encoding="ISO-8859-1"
  
  2) I need to change from qryXML_Out to Case. I'm know that Case is a
  reserved word, so I'd rather not change my schema. Is there another way?
  
  3) I need to add <Item> </Item> to the end of the XML - whats the best way
  to do this?
  
  Thanks!
  Vayse
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  Report abuse