Re: GetChanges, Merge - Returning autoincrement key

Tech-Archive recommends: Speed Up your PC by fixing your registry

Jim,

You need to add this code to your DataAdapters RowUpdated event:
if(e.StatementType == StatementType.Insert)
e.Status = UpdateStatus.SkipCurrentRow;

As per:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q313540

I love the fact that the status is "By design"!!

Cecil Howell MCT, MCAD.NET
www.Ceciltech.com

.