title: parameterise table name in nested repeaters datasource
body: <p>i want to select a column like cl1 from different tables for each row on gridview and show it on my repeater. how can i do this?</p>
  
  <p>here is my code:</p>
  
  <pre><code>&lt;asp:gridview cssclass="text-center table table-bordered table-condensed" id="GridView1" runat="server" autogeneratecolumns="False" datakeynames="PID" datasourceid="SqlDataSource2" emptydatatext="There are no data records to display."&gt;
  &lt;Columns&gt;                                
      &lt;asp:TemplateField HeaderText="مشخصات اختصاصی"&gt;
          &lt;ItemTemplate&gt;
              &lt;asp:Label ID="CatPageLabel" runat="server" Text='&lt;%#Eval("catpage").ToString().Replace(".aspx","") %&gt;'&gt;&lt;/asp:Label&gt;
              &lt;asp:Repeater ID="SecondPageRepeater" runat="server" DataSourceID="SecondPageSqlDataSource"&gt;
                  &lt;ItemTemplate&gt;
                      &lt;%#Eval("cl1") %&gt;
                  &lt;/ItemTemplate&gt;
              &lt;/asp:Repeater&gt;
              &lt;asp:SqlDataSource runat="server" ID="SecondPageSqlDataSource" ConnectionString='&lt;%$ ConnectionStrings:DrB_DBConnectionString %&gt;' SelectCommand='select cl1 from @dest where cl1=3'&gt;
                  &lt;SelectParameters&gt;                        
                      &lt;asp:ControlParameter  Name="dest" ControlID="CatPageLabel"/&gt;
                  &lt;/SelectParameters&gt;
              &lt;/asp:SqlDataSource&gt;
          &lt;/ItemTemplate&gt;
      &lt;/asp:TemplateField&gt;
  &lt;/Columns&gt;
  </code></pre>
  
  <p>
  and this is the error:</p>
  
  <pre><code>Invalid object name '@dest'.
  </code></pre>
  
  <p>thank you</p>