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

Discussion in 'ASP .Net' started by Juan T. Llibre, Jun 12, 2009.

  1. 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" <> wrote in message news:%...
    > 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
    Juan T. Llibre, Jun 12, 2009
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Harry Zoroc
    Replies:
    1
    Views:
    915
    Gregory Vaughan
    Jul 12, 2004
  2. shapper

    Windows 2008 and SQL 2008

    shapper, Dec 8, 2007, in forum: ASP .Net
    Replies:
    1
    Views:
    330
    Mark Fitzpatrick
    Dec 8, 2007
  3. AAaron123
    Replies:
    6
    Views:
    2,475
    AAaron123
    Oct 28, 2008
  4. Eric S
    Replies:
    11
    Views:
    799
    Eric S
    Jun 17, 2009
  5. Marek G.

    IIS 7 , 2008 R2 and SQL 2008

    Marek G., Feb 23, 2010, in forum: ASP .Net
    Replies:
    2
    Views:
    940
    Marek
    Feb 24, 2010
Loading...

Share This Page