title: Reading SQL to DataSet to XmlDocument
body: <p>The code below works dreamy. But can it be made more compact and C#'ish? Especially i have suspicions regarding two issues.</p>
  
  <ol>
  <li>Isn't it ugly (old C-style) filling <code>fill</code> a variable by using it as a in-parameter?</li>
  <li>Can the code be made more compact instead of going through a <code>String</code>?</li>
  </ol>
  
  <p>C#</p>
  
  <pre><code>String
    connectionString = "...",
    sqlStatement = "select * from Test",
    output = "";
  
  SqlDataAdapter adapter = new SqlDataAdapter(sqlStatement, connectionString);
  DataSet dataSet = new DataSet("Contents");
  adapter.Fill(dataSet, "Test");
  StringWriter stringWriter=new StringWriter();
  dataSet.WriteXml(new XmlTextWriter(stringWriter));
  XmlDocument document = new XmlDocument();
  output = stringWriter.ToString();
  document.LoadXml(output);
  </code></pre>