Hi,

I am having problems with updating a row in the database. The scenario is such --

I am using OleDbProvider (MSAccess as the backend). I have a table where the PK is Auto-generated. e.g. say the Table is Customers and the Auto-generated PK is CustomerCode. Now my update query is like --

update Customers set field1 = @field1, ... where CustomerCode = @custcode

Now after filling all the parameters, when I say dtAdap.Update(ds, "Customers"), I get the DBConcurrencyException ?

Please help me with this.

Thanks and Regards,
Manoj.

Be ensure that the parameter for @custcode (supposed named CustCodeParameter) has appropriate version:
CustCodeParameter.SourceVersion = DataRowVersion.Original

HTH.

...but the Soon is eclipsed by the Moon