Solved

Questions about creating XML file

Posted on 2007-03-28
5
159 Views
Last Modified: 2010-04-23
I am running a .net app that needs to email a record to another location. I would like that record to be in XML format. It needs to contain multiple tables from a local MSDE database. There may be one or multiple rows from each table that need to be a part of an export.

On the opposite end, I need to import into a SQL server DB. I am good with that part. I can use the readxml to get it into a temptable in my SP and then use the data from there.. What I am not sure about is how to structure my XML file on the "sending" end so that I can read it on the "receiving" end.

Also, I don't know if there is a "simple" way to do this, or if I am goign to need to manually loop through each dataset and manuall write the XML tags and data.

Thanks for advice/guidance.
Vee
0
Comment
Question by:VeeVan
  • 3
  • 2
5 Comments
 
LVL 12

Expert Comment

by:ullfindsmit
ID: 18808409
there is a dataset.writexml function which will write to a file path given as parameter

also you can do dataset.getxml which returns a string
0
 
LVL 1

Author Comment

by:VeeVan
ID: 18808849
Right, but the way the program is coded right now, each dataset only holds one table from my database. How to I get multiple tables into the same XML file?
0
 
LVL 12

Accepted Solution

by:
ullfindsmit earned 500 total points
ID: 18809106
you would have to write your own functions to have it write to the fiel

something like this

function writeToFile( fileName as string, d as dataset)
  dim fd as new dataset
  fd.readxml( filename)
  fd.tables.add( d.tables(0).copy)

  fd.writexml( filename)

end function

should do the trick
0
 
LVL 1

Author Comment

by:VeeVan
ID: 18809185
Right. I was hoping to avoid recreating my DS, but oh, well. It's easier than manually writing each line to the XML file. Thanks for your help.
Vee
0
 
LVL 12

Expert Comment

by:ullfindsmit
ID: 18809229
glad to help
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This tutorial demonstrates one way to create an application that runs without any Forms but still has a GUI presence via an Icon in the System Tray. The magic lies in Inheriting from the ApplicationContext Class and passing that to Application.Ru…
Introduction When many people think of the WebBrowser (http://msdn.microsoft.com/en-us/library/2te2y1x6%28v=VS.85%29.aspx) control, they immediately think of a control which allows the viewing and navigation of web pages. While this is true, it's a…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question