title: Using multiple tables for one asp net repeater datasource
body: <p>I need to read data from multiple tables and display them in my aspx. So how should I solve this? I have tried to use two repeaters but that does not work either.</p>
  
  <p>C#:</p>
  
  <pre><code>    var node = _administrationSystem.GetNodes(); //DataSet
      var operatorInfo = _administrationSystem.GetOperatorsInformation(userId); //DataSet
  
          var result = (from n in nodes.Tables[0].AsEnumerable()
                    join o in operators.Tables[0].AsEnumerable()
                    on n.Field&lt;int&gt;("NodeIndex") equals o.Field&lt;int&gt;("NodeIndex")
                    select new
                    {
                        ID = o.Table.Columns["ID"],
                        FirstName = o.Table.Columns["FirstName"],
                        SurName = o.Table.Columns["SurName"],
                        NodeName = n.Table.Columns["NodeName"],
                        TranslatorName = o.Table.Columns["TranslatorName"],
                        EMail = o.Table.Columns["EMail"],
                        LastLogin = o.Table.Columns["LastLogin"]
  
                    }).ToList();
  
      rptList.DataSource = result;
      rptList.DataBind();
  </code></pre>
  
  <p>ASPX:</p>
  
  <pre><code>&lt;asp:Repeater runat="server" OnItemCommand="rptList_OnItemCommand" ID="rptList"&gt;
      &lt;HeaderTemplate&gt;
          &lt;table class="tblRegister"&gt;
              &lt;tr class="tblRowHeader" style="background-color: rgb(200,200,200)"&gt;
                  &lt;th&gt;
                      &lt;asp:Label runat="server" Text="TRNSLTFirstname" /&gt;
                  &lt;/th&gt;
                  &lt;th&gt;
                      &lt;asp:Label runat="server" Text="TRNSLTSurname" /&gt;
                  &lt;/th&gt;
                  &lt;th&gt;
                      &lt;asp:Label runat="server" Text="TRNSLTNode index" /&gt;
                  &lt;/th&gt;
                  &lt;th&gt;
                      &lt;asp:Label runat="server" Text="TRNSLTNumber translation" /&gt;
                  &lt;/th&gt;
                  &lt;th&gt;
                      &lt;asp:Label runat="server" Text="TRNSLTEmail" /&gt;
                  &lt;/th&gt;
                  &lt;th colspan="3"&gt;
                      &lt;asp:Label runat="server" Text="TRNSLTLast login" /&gt;
                  &lt;/th&gt;
              &lt;/tr&gt;
      &lt;/HeaderTemplate&gt;
      &lt;ItemTemplate&gt;
          &lt;%# OperatorId.HasValue &amp;&amp; OperatorId == Convert.ToInt32(Eval("ID"))? "&lt;tr &gt;" : "&lt;tr&gt;" %&gt;
              &lt;td&gt;
                  &lt;%# Eval("FirstName") %&gt;
              &lt;/td&gt;
              &lt;td&gt;
                  &lt;%# Eval("SurName") %&gt;
              &lt;/td&gt;
              &lt;td&gt;
                  &lt;%# Eval("NodeIndex") %&gt;
              &lt;/td&gt;
              &lt;td&gt;
                  &lt;%# Eval("TranslatorName") %&gt;
              &lt;/td&gt;
              &lt;td&gt;
                  &lt;%# Eval("EMail") %&gt;
              &lt;/td&gt;
              &lt;td&gt;
                  &lt;%# Eval("LastLogin") %&gt;
                  &lt;asp:Image ClientIDMode="Static" ImageUrl="Images/Icons/Add-22x22.png" ID="AddContact" runat="server" Style="visibility: hidden;" /&gt;
              &lt;/td&gt;
      &lt;/ItemTemplate&gt;
      &lt;FooterTemplate&gt;
          &lt;/table&gt;
      &lt;/FooterTemplate&gt;
  &lt;/asp:Repeater&gt;
  </code></pre>
  
  <blockquote>
    <p>Exception: "Additional information: DataBinding: '&lt;>f__AnonymousType0`2[[System.Data.DataTableCollection, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[System.Data.DataSet, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]' does not contain a property with the name 'FirstName'."</p>
  </blockquote>
  
  <p>Please if you are going to help me create a post, comment does not usually help me.</p>