Don't use a DataSet. It outputs XML in specific ways - namely as elements. Instead, see the classes in the System.Xml namespace. You could enumerate the tables and columns in your DataSet (or use an XmlDataDocument) and then write them out to a file using an XmlTextWriter, which allows you to write attributes, elements, comments, and even processing instructions however you want. Lots of samples are included in the class documentation for the System.Xml namespace. One other option is to save this to a file or a MemoryStream and then load it into an XmlDocument or some other class. You could then use a XslTransform to transform the elements into attributes.
Microsoft MVP, Visual C# My Articles