[dba-VB] XML DOM to string?

Francisco,

I'm not quite sure what you need to do.  You can create the XML from data in your database and you can persist it into a file.  Do you need the ability to read the same XML back into your database (with mods or to receive orders)?

Jim DeMarco

-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com]On Behalf Of Francisco Tapia
Sent: Monday, August 29, 2005 2:25 PM
To: dba-vb at databaseadvisors.com
Subject: [dba-VB] XML DOM to string?


I'm messing around w/ XML and it's quite late I suppose since there
really is so much I do not know... what I'm trying to do, I have a
class that I use to create a complex XML, that is:

I can save my xmldom object down to a file, but then I'd have to
re-open it and read it all back into a string, and I wondered since
it's in memory if I can just somehow save it to a string instead...
any clues?
Thanks


WSOrder>
- <Header>
  <CustID>FO440</CustID> 
  <CompanyName /> 
  <UserType /> 
  <UserNo /> 
  <Address1 /> 
  <Address2 /> 
  <Address3 /> 
  <City /> 
  <State /> 
  <Zip /> 
  <Country /> 
  <Contact /> 
  <Phone /> 
  <Notes /> 
  <ShipMethod /> 
  <PurchaseOrder /> 
  <ShipToID /> 
  <SchedDate /> 
  <Freight /> 
  </Header>
- <OrderItems>
- <WSOrderItem>
  <PartNumber>93-1000</PartNumber> 
  <Quantity>10</Quantity> 
  <SerialNumber>21222</SerialNumber> 
  </WSOrderItem>
- <WSOrderItem>
  <PartNumber>22-2222</PartNumber> 
  <Quantity>5</Quantity> 
  <SerialNumber>50101</SerialNumber> 
  </WSOrderItem>
- <WSOrderItem>
  <PartNumber>33-3333</PartNumber> 
  <Quantity>33</Quantity> 
  <SerialNumber>696969</SerialNumber> 
  </WSOrderItem>
  </OrderItems>
  </WSOrder>


-- 
-Francisco
http://pcthis.blogspot.com |PC news with out the jargon!
http://sqlthis.blogspot.com | Tsql and More...
_______________________________________________
dba-VB mailing list
dba-VB at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-vb
http://www.databaseadvisors.com



***********************************************************************************
"This electronic message is intended to be for the use only of the named recipient, and may contain information from Hudson Health Plan (HHP) that is confidential or privileged.  If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited.  If you have received this message in error or are not the named recipient, please notify us immediately, either by contacting the sender at the electronic mail address noted above or calling HHP at (914) 631-1611. If you are not the intended recipient, please do not forward this email to anyone, and delete and destroy all copies of this message.  Thank You".
***********************************************************************************