title: Is it possible to have DataSet.GetXML() put data in attributes instead of elements?
body: <p>I have a dataset which I am populating via an Oracle SQL query:</p>
  
  <pre><code>SELECT col_id, col_desc
  FROM table_data;
  </code></pre>
  
  <p>Then I generate the dataset, via the function</p>
  
  <pre><code>Dim ds as New DataSet
  OracleDataAdapter.Fill(ds)
  </code></pre>
  
  <p>Now, when I get the XML of the generated dataset via:</p>
  
  <pre><code>Dim strXML as String 
  strXML = ds.GetXML()
  </code></pre>
  
  <p>When I read/display the string, it is showing as follows:</p>
  
  <pre><code>&lt;NewDataSet&gt;
    &lt;Table&gt;
      &lt;COL_ID&gt;ABC001&lt;/COL_ID&gt;
      &lt;COL_DESC&gt;Angelo&lt;/COL_DESC&gt;
    &lt;/Table&gt;
    &lt;Table&gt;
      &lt;COL_ID&gt;ZFE851&lt;/COL_ID&gt;
      &lt;COL_DESC&gt;John&lt;/COL_DESC&gt;
    &lt;/Table&gt;
    &lt;Table&gt;
      &lt;COL_ID&gt;XYU123&lt;/COL_ID&gt;
      &lt;COL_DESC&gt;Mary&lt;/COL_DESC&gt;
    &lt;/Table&gt;
    &lt;Table&gt;
      &lt;COL_ID&gt;MLP874&lt;/COL_ID&gt;
      &lt;COL_DESC&gt;James&lt;/COL_DESC&gt;
    &lt;/Table&gt;
  &lt;/NewDataSet&gt;
  </code></pre>
  
  <p>What I want is that the resulting string should rather display as follows:</p>
  
  <pre><code>&lt;NewDataSet&gt;
    &lt;Table COL_ID="ABC001" COL_DESC="Angelo"&gt;&lt;/Table&gt;
    &lt;Table COL_ID="ZFE851" COL_DESC="John"&gt;&lt;/Table&gt;
    &lt;Table COL_ID="XYU123" COL_DESC="Mary"&gt;&lt;/Table&gt;
    &lt;Table COL_ID="MLP874" COL_DESC="James"&gt;&lt;/Table&gt;
  &lt;/NewDataSet&gt;
  </code></pre>
  
  <p>How would I be able to accomplish this?</p>
  
  <p>Would it be easy if say, I would read the rows from the table in the dataset and construct the string?</p>