title: binding linq query result to gridview
body: <p>I am finding it difficult to bind the linq query results to a gridview control on my asp.net page.  In the main Linq Query, i am getting all the users from one table which meets the criteria of a column that checks for "Form Completed" - </p>
  
  <pre><code>using (COLA_AccreditationEntities4 eFactory = new COLA_AccreditationEntities4())
  {
      var evaluations = eFactory.Symposium_Evaluation.Where(a =&gt; 
              (!a.Completed.HasValue || 
                a.Completed.Value == 0) &amp;&amp; a.Active &amp;&amp; a.UserID &gt;= 2063).ToList();
  </code></pre>
  
  <p>Then inside the code i am doing a foreach loop to get all the userid from the other table that matches the userid in the previous table - </p>
  
  <pre><code>foreach (var eval in evaluations)
  {
      var user = eFactory.SYMPOSIUM_Users.Where(a =&gt; a.UserID == eval.UserID.Value 
                           &amp;&amp; a.Active.Value &amp;&amp; a.UserRole == 1).FirstOrDefault();
  
      if (user != null &amp;&amp; !users.Contains(user.UserID))
      {
          string name = user.FirstName + " " + user.LastName;
          string email = user.Email;
      }
  }
  </code></pre>
  
  <p>All i wanted to do is to show the user.firstname + user.lastname + user.email on the screen.  I used gridview control to bind this, but not getting desired results.</p>
  
  <p>Any thoughts on how to achieve this ?</p>