title: Group/merge multiple records as one gridview row
body: <p>I would like to know how to make multiple records into a single gridview row. Take a look at the following example.</p>
  
  <p>Data Source:  </p>
  
  <pre><code>FAMILY        GROUP              COLOR
   Dog          Poodle              Blue
   Dog          German Shepherd     Red
   Dog          Pitubll             orange
   Cat          Evil                Green
   Cat          Tabby               purple
  </code></pre>
  
  <p>I am trying to create the following look in a gridview</p>
  
  <pre><code>      FAMILY       GROUP              COLOR
  ===============================================
        |        |   Poodle           |  Blue
  ROW1  | DOG    |   German Shepherd  |  Red
        |        |   Pitbull          |  Orange
  ===============================================
        |        |   Evil             |  green
  ROW2  | CAT    |   tabby            |  purple
  </code></pre>
  
  <p>The Family column (if there are multiple) will appear as ONE cell, with each corresponding sub category appearing as its own respective row.</p>
  
  <p>This way when the user selects the row, the whole row of type FAMILY is selected. Each row is based off the FAMILY, so regardless of how many rows may be in group and colors, it would still be ONE family row. Essentially the gridview is mainly to show information about the FAMILY and the GROUP/COLOR is just strictly used for details about the family.</p>
  
  <p>Is this something that should be done in SQL or through the Gridview bind events? How would I accomplish my goal?</p>
  
  <p>If my explanation has been unclear just let me know and I will try to clarify.</p>