title: Update requires a valid UpdateCommand when passed DataRow collection with modified rows
body: <p>So I had this working last week.  At least, I thought I did!
  <a href="https://stackoverflow.com/questions/548091/datagridview-update">DataGridView Update</a></p>
  
  <p>Then I start working on the project again today and am getting </p>
  
  <blockquote>
    <p>Update requires a valid UpdateCommand when passed DataRow collection
    with modified rows.</p>
  </blockquote>
  
  <p>On </p>
  
  <pre><code>scDB.SSIS_Configurations_StagingDataTable table = (scDB.SSIS_Configurations_StagingDataTable)stagingGrid.DataSource;
  myStagingTableAdapter.Update(table);
  </code></pre>
  
  <p>The <code>StagingTableAdapter</code> has an additional query which takes 'filter' as a parameter. That was used to fill the <code>DataGridView</code>.  In the wizard for creating that query I see 'update was generated'.  I see that most posts with this error require that an update statement be generated with a command builder.  What do I do? </p>