Results 1 to 3 of 3

Thread: ado.net

  1. #1

    Thread Starter
    Fanatic Member
    Join Date
    Dec 2002
    Location
    London
    Posts
    678

    ado.net

    Can someone please point me out to where I can get good examples on how to transfer the data from .xml file into a table in database.
    Thanks

  2. #2
    Frenzied Member
    Join Date
    Oct 2002
    Location
    Gammapolis
    Posts
    1,474
    You can easily trasnfer data from xml to datasets, but then transfering data to a database is sometimes a pain in the neck. If the tables and relations are pre built then you can easily tranfer it to database too. But if not you have to use make table queries for SQL Server and maybe ADOX for Access to build tables and relationships. Access has import xml feature but it does not import relationships.
    'Heading for the automatic overload'
    Marillion, Brave, The Great Escape, 1994

    'How will WE stand the FIRE TOMORROW?'
    Eloy, Silent Cries and Mighty Echoes, The Vision - Burning, 1979

  3. #3

    Thread Starter
    Fanatic Member
    Join Date
    Dec 2002
    Location
    London
    Posts
    678

    a

    There is a table in the sql database which can take the same fields in xml file. Do you know how to do this? Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width