creating xml file from sql vs 2005

[svibuk]

i am using vs 2005 and creating xml file from sqlusing dataset & datadapter & xmlwriterqueries1) the xml file created needs to be fromated .i mean i need to change the elements , nodes positioning as per the given structure how do i do it?

[Ccssrs69]

i am using vs 2005 and creating xml file from sqlusing dataset & datadapter & xmlwriterqueries1) the xml file created needs to be fromated .i mean i need to change the elements , nodes positioning as per the given structure how do i do it?

I don't know if it would be easier to create a sql query and do a FOR XML AUTO in your query. You can format the xml in table variables.