title: Direct method from SQL command text to DataSet
body: <p>What is the most direct route to get a DataSet if I have a sql command?</p>
  
  <pre><code>string sqlCommand = "SELECT * FROM TABLE";
  string connectionString = "blahblah";
  
  DataSet = GetDataSet(sqlCommand,connectionString);
  
  GetDataSet()
  {
     //...?
  }
  </code></pre>
  
  <p>I started with <code>SqlConnection</code> and <code>SqlCommand</code>, but the closest thing I see in the API is <code>SqlCommand.ExecuteReader()</code>.  With this method, I'll need to get a <code>SqlDataReader</code> and then convert this to a <code>DataSet</code> manually.  I figure there is a more direct route to accomplish the task.</p>
  
  <p>If easier, a <code>DataTable</code> will also fit my goal.</p>