Questions about creating XML file

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.
Who is Participating?
ullfindsmitConnect With a Mentor Commented:
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
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
VeeVanAuthor Commented:
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?
VeeVanAuthor Commented:
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.
glad to help
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.