title: Asp.net c# multiple value in a single column of gridview
body: <p>How can I show multiple value in a single column of a <code>GridView</code>? For example when I search "Ivan" in the <code>TextBox</code>, the output will return multiple rows of Ivan like this:</p>
  
  <blockquote>
    <p><strong>Name Task</strong>
    <br/>Ivan Task1
    <br/>Ivan Task2
    <br/>Ivan Task3</p>
  </blockquote>
  
  <p>I want something like this</p>
  
  <blockquote>
    <p><strong>Name Task</strong>
    <br/>Ivan Task1, Task2, Task3</p>
  </blockquote>
  
  <p>My Table is like this</p>
  
  <blockquote>
    <p><strong>Employee</strong> (id,name)
    <br/><strong>Task</strong>(id,name)
    <br/><strong>EmployeeTask</strong>(employee.id,task.id)</p>
  </blockquote>
  
  <p>Here is my sql code</p>
  
  <pre><code>SELECT  e.name,  t.name
  FROM EmployeeTask et
  INNER JOIN employee e ON e.id = et.employee_id
  INNER JOIN task t ON t.id = et.task_id
  WHERE e.name = @Name
  </code></pre>
  
  <p>And this is my <code>GridView</code> mark up</p>
  
  <pre><code>&lt;Columns&gt;
      &lt;asp:BoundField DataField="name" HeaderText="Name" SortExpression="name"/&gt;
      &lt;asp:BoundField DataField="task" HeaderText="Task" SortExpression="task"/&gt;        
  &lt;/Columns&gt;
  </code></pre>