title: Return rows from multiple requests with datatable vb.net
body: <p>If I have two or more queries in the same command:</p>
  
  <pre><code>Using myCommand As New OracleCommand(
  "select value from table where id between 1 and 3;" &amp; 
  "select value1 from table where id = 1000", DBSettings.GetConnection())
  </code></pre>
  
  <p>and I have <code>DataTable</code> which select the values from the first request</p>
  
  <pre><code>Dim dt As DataTable = New DataTable
  dt.Load(myCommand.ExecuteReader)
  
  value1 = dt.Rows(0).Item(0).ToString().Trim()
  value2 = dt.Rows(1).Item(0).ToString().Trim()
  value3 = dt.Rows(2).Item(0).ToString().Trim()
  </code></pre>
  
  <p>Can I get values throuth DataTable from second request? Is it possible, that my values get the rows from the following requests? </p>
  
  <p>I do not want to create a a lot of commands and DataTable, because I have a lot of commands and the values that I need to initialize</p>