title: Sql DataBase does not update changes
body: <p>I get the error message below</p>
  
  <blockquote>
    <p>Dynamic sql generation for the update command is not supported against a select command that does not return any key column information</p>
  </blockquote>
  
  <p>when I try to update my database via a button click after I made changes in <code>GridView</code>. Below is the code:</p>
  
  <pre><code>private void updateDB_Click(object sender, EventArgs e)
  {
      SqlDataAdapter sqlAdapter = new SqlAdapter(@"SELECT [Customer],[Employee],[Product],[State] FROM [Table1]", connection);
      sqlCmdBuilder = new SqlCommandBuilder(sqlAdapter);
      DataTable datTable = dataGridView1.DataSource as DataTable;
      sqlAdapter.Update(datTable);
  }
  </code></pre>
  
  <p>I have searched a lot to find a solution but I can't find something useful. I know that this is because a <code>PrimaryKey</code> is missing in my database but it is supposed that there is none. </p>
  
  <p>So how can I update my database after changes were made without having a <code>PrimaryKey</code> defined? Is it possible to use another way where I can only use my column names and the tablename (I have only found a solution where each element has to be written manually and that's too much)? </p>