title: Displaying parent/child data in a gridview
body: <p>I'm trying to create a document that displays a list of items, with details below each item.  I feel like what I'm trying to do should be relatively simple, and the answer is hiding under my nose, but I can't find what I'm looking for.  </p>
  
  <p>For an example, let's say I'm just listing people, with a child list of their favorite foods.</p>
  
  <p>This is how the data will eventually be displayed:</p>
  
  <pre><code>DOE,      JOHN       AGE:31
        Apple
        Pie
        Cookies
  
  SMITH,    JANE       AGE:95
        Oats
        Bananas
        Prunes
  </code></pre>
  
  <p>I'm returning a single table from the database structured as such:</p>
  
  <pre><code>USERID  LASTNAME  FIRSTNAME  AGE  FAVORITEFOOD
  100     DOE       JOHN       31   Apple
  100     DOE       JOHN       31   Pie
  100     DOE       JOHN       31   Cookies
  101     SMITH     JANE       95   Oats
  101     SMITH     JANE       95   Bananas
  101     SMITH     JANE       95   Prunes
  </code></pre>
  
  <p>I'm trying to do this with a gridview control.  I'm not sure that's what I should be using.  But what I'm having trouble with, is getting the gridview to only list items with a unique USERID.  And then using that unique USERID to list each item individually below.</p>
  
  <p>Is there any kind of "automated" way of pulling this off using standard .net controls without going in and manually piecing it all together from the codebehind?</p>
  
  <p>Thanks</p>