title: Display records from another table in an existing GridView
body: <p>Here is an example of the problem I am facing. I have a table called Issues, which has the initial record information. Each record also has a category and some have multiple categories.</p>
  
  <p>Issues</p>
  
  <pre><code>ID | Name        | Comments        | Date     | SubmittedBy
  1  | Server down | Need assistance | 6/1/2015 | John
  </code></pre>
  
  <p>IssuesCategories</p>
  
  <pre><code>ID | Name
  1  | Internal
  2  | External
  3  | Mobile
  4  | Email
  </code></pre>
  
  <p>IssuesCatList</p>
  
  <pre><code>QID | CID
  1   | 1
  1   | 3
  1   | 4
  </code></pre>
  
  <p>I am trying to display all of this in one GridView that looks like this:</p>
  
  <pre><code>Name        | Categories              | Date     | By
  Server down | Internal, Mobile, Email | 6/1/2015 | John
  </code></pre>
  
  <p>So I want to place the category names into the a column of the gridview. How can I accomplish this? Can this be done with the SQL query or do I need to do this in the RowDataBound in the code behind?</p>
  
  <pre><code>&lt;asp:GridView runat="server" ID="issuesView" CssClass="table" OnRowDataBound="issuesView_RowDataBound"
      GridLines="None" EmptyDataText="No issues" AutoGenerateColumns="False"&gt;
      &lt;Columns&gt;
          &lt;asp:BoundField DataField="Name" HeaderText="Name" /&gt;
          &lt;asp:BoundField DataField="Date" DataFormatString="{0:M/d/yy}" HeaderText="Date" /&gt;
          &lt;asp:BoundField DataField="SubmittedBy" HeaderText="By" /&gt;
      &lt;/Columns&gt;
  &lt;/asp:GridView&gt;
  </code></pre>