title: DataGridView inserts primary key
body: <p>I'm trying to get a basic DataGridView to insert new rows into a table. The table has an auto incrementing primary key (Identity 1,1) and I'm having two problems with this. </p>
  
  <p>The first problem is the DataSet which the DataGridView is populated from complains that the primary key in the row is null (I hide the primary key field from the DataGridView). </p>
  
  <p>This problem disappears when I disable constrain checking or modify the DataSet to ignore the primary key being null.</p>
  
  <p>The next problem is SQL Server complains about the DataSet trying to insert a value into the primary key field. It doesn't like it when the DataSet specifies the value for the primary key.</p>
  
  <p>I'm very new to using C# and I've never used a DataGrid before.</p>