Solved

Questions about creating XML file

Posted on 2007-03-28
5
158 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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

Article by: jpaulino
XML Literals are a great way to handle XML files and the community doesn’t use it as much as it should.  An XML Literal is like a String (http://msdn.microsoft.com/en-us/library/system.string.aspx) Literal, only instead of starting and ending with w…
A while ago, I was working on a Windows Forms application and I needed a special label control with reflection (glass) effect to show some titles in a stylish way. I've always enjoyed working with graphics, but it's never too clever to re-invent …
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

776 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