title: Programmatically Add Row to Linq-to-SQL Dataset
body: <p>Let's say we generate this link-to-sql dataset for a grid:</p>
  
  <pre><code>var query = from c in customers
                      orderby c.FirstName
                      select c;
  
  Grid1.DataSet = query;
  Grid1.DataBind();
  </code></pre>
  
  <p>After generating this dataset, we need to programmatically add "Vince Vaughn" to this dataset (the goal is to add a row to this linq-to-sql dataset so that the values obtained from the database, and the 1 row that was programmatically added, all appear in the grid).</p>
  
  <p>How would be accomplish this programmatically using C#? (i.e. programmatically add a row for Vince Vaughn to the dataset)</p>
  
  <pre><code>CUSTOMERS TABLE
  ID     FirstName    LastName    
  1      John         Jones    
  2      Sally        Smith
  </code></pre>
  
  <p>Environment: C#.NET 4.0</p>
  
  <p>Thank you in advance.</p>