title: Dynamic rows & columns for Gridview
body: <p>I have a scenario where I have 3 tables (<code>Employees</code>, <code>Tasks</code>, <code>EmployeeTaskTimes</code>) I need to generated a gridview in c# with list of <code>Task</code> on the vertical scale (rows), and <code>Employees</code> on horizontal scale (columns) and fill in the values from the <code>EmployeeTaskTimes</code>. </p>
  
  <p>basic layout for the tables is: </p>
  
  <blockquote>
    <p><em>Employees:</em>
        IdEmp;
        Name;</p>
    
    <p><em>Tasks:</em>
    IdTask
    Title;</p>
    
    <p><em>EmployeeTaskTimes:</em>
    IdEmpTaskTime;
    IdTask
    IdEmp;
    TimeTaken;</p>
  </blockquote>
  
  <p>I have run into three headaches that I need suggestions:</p>
  
  <ol>
  <li>Creating columns based on the dataset from <code>Employees</code>. (dynamically?)</li>
  <li>A reasonable query(s) to generate a dataset consumable by the gridview</li>
  <li>bind the values to the grid.</li>
  </ol>
  
  <p>Any suggestions are appreciated</p>