title: Presenting and Grouping Data ASP.NET / SQL
body: <p>I'm going to try and do a different take on this as my last attempt wasnt clear:</p>
  
  <p>I have run an SQL query and produced the following results:</p>
  
  <p><img src="https://i.stack.imgur.com/HX2Ae.png" alt="enter image description here"></p>
  
  <p>I now want to build an ASP.NET page that displays these results to the user</p>
  
  <p>I am trying to place a listview to show the user, and inside this, a gridview to display the items the user has.</p>
  
  <p>So far my code looks like this:</p>
  
  <pre><code> &lt;asp:ListView ID="lvPersonItems" runat="server"  DataSourceID="sdsResults"  GroupItemCount="3"  EnableViewState="true" GroupPlaceholderID="groupPlaceHolder" ItemPlaceholderID="itemPlaceHolder"&gt;
  
   &lt;LayoutTemplate&gt;
   &lt;table&gt;
   &lt;tr&gt;
   &lt;td&gt;
   &lt;table cellpadding="15"&gt;
   &lt;asp:PlaceHolder ID="groupPlaceHolder" runat="server" /&gt;
   &lt;/table&gt;
   &lt;/td&gt;
   &lt;/tr&gt;
   &lt;/table&gt;
   &lt;/LayoutTemplate&gt;
  
   &lt;GroupTemplate&gt;
      &lt;tr&gt;
      &lt;asp:PlaceHolder ID="itemPlaceHolder" runat="server" /&gt;
      &lt;/tr&gt;
   &lt;/GroupTemplate&gt;
  
   &lt;ItemTemplate &gt;
   &lt;td&gt;
   &lt;h3&gt;&lt;%# Eval("Forename")%&gt; &lt;%# Eval("Surname")%&gt;&lt;/h3&gt;
  
   &lt;asp:GridView BorderStyle="None" ID="gvItems" AutoGenerateColumns="false" runat="server" DataSource='&lt;%# Eval("Description") %&gt;'&gt;
  
   &lt;Columns&gt;
   &lt;asp:BoundField DataField="Description" HeaderText="Description" /&gt;
   &lt;/Columns&gt;
  
   &lt;/asp:GridView&gt;
  
   &lt;EmptyDataTemplate&gt;
   &lt;div style="background-color:Gray"&gt;No orders exists!&lt;/div&gt;
   &lt;/EmptyDataTemplate&gt;
  
   &lt;/td&gt;
    &lt;/ItemTemplate&gt;
   &lt;/asp:ListView&gt;
  
    &lt;asp:SqlDataSource ID="sdsResults" runat="server" 
            ConnectionString="&lt;%$ ConnectionStrings:conString %&gt;" 
            SelectCommand="sp_Test_Proc" SelectCommandType="StoredProcedure"&gt;
          &lt;/asp:SqlDataSource&gt;
  </code></pre>
  
  <p>However, upon running this, I am getting the following error:</p>
  
  <pre><code>A field or property with the name 'Description' was not found on the selected data source.
  </code></pre>
  
  <p>Can anybody shed some light on this? :)</p>
  
  <p><strong>UPDATE</strong></p>
  
  <p>Following Icarus's advice, I now have the following:</p>
  
  <p><img src="https://i.stack.imgur.com/1dtEI.png" alt="enter image description here"></p>
  
  <p>However, it contains multiple data , I can't seem to condense this to 2 users, 1 with 2 items and another with 1 item.</p>