>Here is some VB.NET sample that demonstrates how to get AUTOINC value back after Insert:
Thanks, this is some very interesting good. In the first approach, as the value of the auto incremental field is returned in a secondary command into the adapter, does this guarantee that the value returned is in fact the incremental key that was generated by the insert command in this code? By that, I mean that if two users are executing this code, is there a chance that the value returned is the value of the insert of the other user? Assuming yes, does that mean that the second implementation using the event handler would guarantee this?