title: Querying with Datatable a combination of multiple select in one row
body: <p>I'll proceed to explain by showing you a simple example</p>
  
  <pre><code>table NAMES
   ID_NAMES
   NAME
  
  table AGES
   ID_AGES
   AGE
  </code></pre>
  
  <p>this is my query</p>
  
  <pre><code>SELECT 
  ( 
    select NAME
    from NAMES 
    where ID_NAME=1
  ) as thisismyname,
  (
    select AGE
    from AGES
    where ID_AGE=50
  ) as thisiymyage
  </code></pre>
  
  <p>I'm expecting results like</p>
  
  <pre><code>thisismyname, thisismyage
  </code></pre>
  
  <p>I'm perfectly aware that it's completely stupid, because I could do a join and get an easy query, but there is NO links between tables and this will be a result of a combination of 50 select, not just two.</p>
  
  <p>It's working, but I want a DataTable where I can query with just using</p>
  
  <pre><code> mydatatable[0]["thisismyname"]
  </code></pre>
  
  <p>Actually it's giving me results only with an ExecuteScalar, and SQLDataReader gives me empty DataTable</p>
  
  <pre><code>using (var conn = Connection)
  {
    DbCommand mycommand = GetCommand(conn, sql);
    DbDataReader reader = mycommand.ExecuteReader();
    dt.Load(reader);
    reader.Close();
    conn.Close();
  }
  </code></pre>