Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Re: Is there a way to convert ms sql 2008 tables to XML files?

Reply
Thread Tools

Re: Is there a way to convert ms sql 2008 tables to XML files?

 
 
Juan T. Llibre
Guest
Posts: n/a
 
      06-12-2009
re:
!> Is there a way to convert ms sql 2008 tables to XML files?

Create a stored procedure which contains the select statement you wish to use.

Make sure that the select statements creates the XML data
the way you want it, using the FOR XML AUTO clause.

Then use System.IO to write the returned data to a file.




Juan T. Llibre, asp.net MVP
¿ Estas probando VS 2010 y ASP.NET 4.0 ?
Regístrate (gratis) en los Foros de VS 2010 y ASP.NET 4.0, en español
http://asp.net.do/foros/forums/
================================================== ===
"Eric S" <(E-Mail Removed)> wrote in message news:%(E-Mail Removed)...
> Hi All,
>
> Is there a way to convert ms sql 2008 tables to XML files?
> Say I have several tables related to each other and I want to create the
> hierarchy of the data such as parent child within the XML Any hidden class somewhere
> to perform the above?
>
> These are small tables where I store the data of menu options and sub
> options etc...
>
> Thanks,
>
> Eric




 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is there a way to convert ms sql 2008 tables to XML files? Eric S ASP .Net 11 06-17-2009 04:33 PM
Copy SQL SERVER 2008 database to sql Express 2008 AAaron123 ASP .Net 6 10-28-2008 03:39 PM
Tools to extract data from SQL database and convert it into XML & insert XML data into SQL databases Harry Zoroc XML 1 07-12-2004 10:10 PM



Advertisments