Ok, I have read about every thread relating to this and still cant come to a conclusion on how to do this properly. the .WriteXML is out of the question because it writes a lot of garbage i dont need, the .GetMultiAsDataTable is all good but it only brings back 1 Level. I read somewhere that i can generate a document using a for but i wasnt sure what the poster was refering to as far as looping to create the document and its children. I think there should be a .WriteXML overloaded to just do clean version of the document.

If anyone has already done this please post your solution thanks

Please read about the "Compact XML", in the "Using the generated code"-> "Adapter/SelfServicing"-> "XML support"

This will show you how to generate lighter XML using WriteXML()