How to: Generate XML file from database table

Sign in to leave a comment.

• VP

  Vijay Patel16y agoPosted Mar 27, 2010, 1:23 AM

  Hi Rahul, Great Job Dude, your code is really very useful for me. I have some issues like, how can change Tags like <NewDataSet>, <Table> etc, How can I add Attribute in <Table> tag? Because I need more table data in single XML file. Thanks in Advance, Regards.
• RG

  Rumba Girl19y agoPosted Aug 15, 2007, 12:25 PM

  Hello, I am having an exercise about transforming a table to XML file, the table contains the following: Name, First name, Address, Email, Phone N1 P1 A1 [email protected] 83343 N2 P2 A2 [email protected] 34343 We consider Email and Phone as attributes, Could you please tell me how to write it in XML? Thanks
• CK

  Chand K19y agoPosted Jul 9, 2007, 3:59 AM

  Excellent work...Keep it up
• UL

  Unlink link19y agoPosted Jun 30, 2007, 10:44 PM

  Tks for the brilliant article. Very helpful! I have a question and I hope you can help out. I am trying to write this file to my webserver. But instead it tries to write to the D: folder (as stated in the article). How can I do it to write in the webserver. When running at my localhost it runs fine, but when running in my webhost it gives me an error saying that I do not have permissions since it is trying to access the C: file. Any suggestions. Really appreciate some help. Thank you.
  • S

    Simon19y agoPosted Jul 10, 2007, 3:46 AM

    i'dd like a good solution for this aswell one solution I could think of though was to exclude the D:/ and just keep the rest of the filename, shouldn't this put the file in the same directory as the aspx file?
• RP

  Rodrigo Perez19y agoPosted Jun 20, 2007, 1:44 PM

  Nice piece of code for getting xml right from a db.
• AS

  Amit sp19y agoPosted Jun 19, 2007, 3:41 PM

  Hi, This is really a nice approach. But i will prefer using an alternative simpler approach... strXML = dataset.getxml