title: Using SQLAdapter.Update(Dataset) Throws error "No primary key in select command"
body: <p>In short, C# throws me "Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information", while the table in question DOES have a Primary key (Identity, since it's MSSQL).</p>
  
  <p>My code is as following: </p>
  
  <pre><code>       void loaddata()
      {
          try
          {
              DS = new DataSet();
              sqladapt = new SqlDataAdapter("SELECT servicetag,name,defect,primkey FROM " + Properties.Settings.Default.DBtableLaptops + "", sqlcon);
              sqladapt.FillSchema(DS, SchemaType.Source);
              sqladapt.Fill(DS);
              commandBuilder = new SqlCommandBuilder(sqladapt);
              DT = DS.Tables[0];
              Laptops_datagridview.DataSource = DT; //I'm using a datagridview to edit the data.
          }
          catch (Exception ex)
          {
              MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
          }
  
      }
      void savedata()
      {
          //Doesn't work yet.
          try
          {
              sqladapt.Update(DS); // &lt;-- Throws the aforementioned error.
              sqladapt.Dispose();
          }
          catch (Exception ex)
          {
              MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
          }
      }
  </code></pre>
  
  <p>Data loading etc works fine, Adding new rows works aswell, and it saves it. But whenever i update or delete a row, it throws the error. 
  Primkey is my primary key, it's an auto-incrementing integer.</p>
  
  <p>I've been googling all day, but to no avail, the usual problem people have is that there is no primary key defined in the first place, but that's not the case here. </p>
  
  <p>Any input would be greatly appreciated, i've been shotgun-debugging for like 6 hours now.</p>
  
  <p>EDIT: 
  The create statements for the table in question is as following: </p>
  
  <pre><code>CREATE TABLE [dbo].[laptopregistratieDB_laptops](
      [Servicetag] [text] NOT NULL,
      [Name] [text] NOT NULL,
      [Defect] [bit] NOT NULL,
      [primkey] [int] IDENTITY(1,1) NOT NULL
  ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
  </code></pre>