I need to create an XML file which is in a pre-defined format (All the tags
are defined) from data extracted from a SQL Server database. The XML should
be created in such a way that the tags should match the right data, for e.g.
the XML will have a tag <AccountName></AccountName> and the datatable will
have a column AccountName.

What is the best way to do this ?

[quoted text, click to view]

You can use a specialized tool able to import SQL Server database
content directly into the XML format. You can check oXygen 6.2
(http://www.oxygenxml.com) that does this job (see a demo at
http://www.oxygenxml.com/demo/importDB/importDB.html)
The upcoming version 7.0 (available as beta at
http://www.oxygenxml.com/download-beta.html) is even able to generate a
XML Schema based on the database structure for your imported file.

---------------------------------------------------------------------
Stefan Vasile
<oXygen/> XML Editor, Schema Editor and XSLT Editor/Debugger
http://www.oxygenxml.com/