So I am trying to figure this databinding thing out, slowly getting there, this is probably a simple question but I have a form that I want to add a new record on open, so in the load event I call BindingNavigatorAddNewItem.PerformClick(), which works. Right now I have one field in the form, the only mandatory field in that table. I click save, it saves the first record, I think call BindingNavigatorAddNewItem.PerformClick() again to go to a new record. When I enter data this time and hit save, i get Violation of UNIQUE KEY constraint 'pk_flightplan'. Cannot insert duplicate key in object 'dbo.flightplan'. My table has an id field which is an identity column. When I click save, i get that error. How come it isnt creating the new row with the next higher id and allowing me to save it.
I get that error on this line
Me.TableAdapterManager.UpdateAll(Me.FlightTestAppDataSet)
I get that error on this line
Me.TableAdapterManager.UpdateAll(Me.FlightTestAppDataSet)