Append data in datatable
<p>Is there any solution i can append data to one datatable. </p>

<p>Example i have for loop which execute "Select " query on database. I store the result in a datatable. On second loop i will execute "Select " query once again but this time i will get different results. Is there any way i can store all those data into one datatable without loosing the data from previous loop</p>

<p>Dummy example </p>

<pre><code>    For i = 0 To 10
        _cmd.CommandText = _sQ ' With different parameter in this query
        _da.SelectCommand = _cmd
        _da.Fill(_dt)
    Next
</code></pre>

<p>At the end my _dt should contain all data from this 10 iterations.</p>