title: How can I bind multiple SQL queries to a single asp repeater
body: <p>So I have a query that looks like this:</p>
  
  <pre><code>SqlCommand cmd = new SqlCommand();
  cmd.CommandText = "SELECT * From Table1 WHERE conditions";
  DataTable tempTable = helper.ExecuteQuery(cmd);
  tempTable.TableName = "MainRecords";
  ds.Tables.Add(tempTable);
  </code></pre>
  
  <p>where ds is a DataSet (global variable) and then in another function I bind my information to an asp:Repeater named MainRecords like this:</p>
  
  <pre><code>MainRecords.DataSource = ds.Tables["MainRecords"];
  MainRecords.DataBind();
  </code></pre>
  
  <p>My question is how can I bind a second query (like the one above but with different results) to the same repeater so I can display them simultaneously,  something like this: </p>
  
  <pre><code>&lt;asp:Repeater ID="MainRecords" runat="server"&gt;
  &lt;ItemTemplate&gt;
      &lt;tr&gt;
          &lt;td&gt;&lt;%# DataBinder.Eval(Container.DataItem, "InfoFromTable1")%&gt;&lt;/td&gt;
          &lt;td&gt;&lt;%# DataBinder.Eval(Container.DataItem, "InfoFromTable2")%&gt;&lt;/td&gt;
      &lt;/tr&gt;
  &lt;/ItemTemplate&gt;
  &lt;/asp:Repeater&gt;
  </code></pre>
  
  <p>I found some things here but nothing seemed to help me.</p>