Multiple Bindings to a GridView DataSource
<p>I am trying to bind three queries to a GridView DataSource. From my understanding you can't bind more then one query to a GridView DataSource, Is this true? Is so, how would you go about taking multiple queries and binding them to one GridView. For example:</p>

<pre><code>var query1 = select * from table 1
var query2 = select * from table 2
var query3 = select * from table 3


GridView.DataSource = query1;
GridView.DataSource = query2;
GridView.DataSource  = query3;
</code></pre>

<p>This is basically what I want to do, but from what I can find this is possible. Is there a good way to do something like this? Thanks!</p>

<p>So, basically I have multiple queries and I need certain results from all of them to go into one GridView.</p>
