title: Linq Datagrid Source Link Each Row
body: <p>Okay I do not even know where to begin when it comes to this I am continuing from this question: <a href="https://stackoverflow.com/questions/2664029/linq-to-sql-statement-issue">Linq-to-SQL statement issue</a></p>
  
  <p>Where I searched multiple columns in a table and returned my values in a datagrid,
  Ive done basic formatting on the grid but am unable to decipher how I would go about
  getting each row to link to another page?</p>
  
  <pre><code>using (TiamoDataContext context = new TiamoDataContext())
      {
          var search = 
               from p in context.UserProfile1s
               where p.DanceType == UserSearchString ||
                     p.Username == UserSearchString ||
                     p.Occupation == UserSearchString ||
                     p.LookingFor == UserSearchString ||
                     p.Location == UserSearchString ||
                     p.LastName == UserSearchString ||
                     p.Gender == UserSearchString ||
                     p.FirstName == UserSearchString ||
                     p.DanceType == UserSearchString ||
                     p.DanceSong == UserSearchString ||
                     p.DanceLevel == UserSearchString ||
                     p.DanceIcon == UserSearchString ||
                     p.BodyBuild == UserSearchString ||
                     p.Age.ToString() == UserSearchString ||
                     p.AboutMe == UserSearchString
               select new
               {
                   Username = p.Username,
                   Firstname = p.FirstName,
                   Lastname = p.LastName,
                   Location = p.Location,
                   DanceType = p.DanceType
               };
  
          UserSearchGrid.DataSource = search;
          UserSearchGrid.DataBind();
      }
  </code></pre>
  
  <p>And</p>
  
  <pre><code>&lt;asp:GridView ID="UserSearchGrid" runat="server" CellPadding="4" ForeColor="#333333" GridLines="None" Height="93px" Width="702px"&gt;
      &lt;RowStyle BackColor="#EFF3FB" /&gt;
      &lt;FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" /&gt;
      &lt;PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" /&gt;
      &lt;SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" /&gt;
      &lt;HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" /&gt;
      &lt;EditRowStyle BackColor="#2461BF" /&gt;
      &lt;AlternatingRowStyle BackColor="White" /&gt;
  &lt;/asp:GridView&gt;
  </code></pre>
  
  <p>Thanks I know you guys have helped me loads today I am just enjoying this too much its fuuun....</p>