Solved

Questions about creating XML file

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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
I need C# converted to VB.net 1 53
Code enhancement 5 14
Clone Visual studio 2013 solution 5 17
Red error squiggly on vb.net 7 14
This article explains how to create and use a custom WaterMark textbox class.  The custom WaterMark textbox class allows you to set the WaterMark Background Color and WaterMark text at design time.   IMAGE OF WATERMARKS STEPS Create VB …
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

744 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now