Editing data in a grid and updating error

Question

Here is the components im using to update the data into database: dataset - fbDataAdapter - fbCommand - fbConnection Inside the dataset i've create the following table : Service1 Customer Contract etc (in this case I'll only use the Service1 Table) .. The problem is when I'm editing the data inside the grid(the grid is link to DataSet Service table) and press Update button the error occurs. The Update function is wrote as following : gridDisplayServiceMaintenance.MainView.UpdateCurrentRow(); if (fbConnection1.State.ToString() == Closed) fbConnection1.Open(); FirebirdSql.Data.Firebird.FbCommandBuilder FbComBuilder = new FirebirdSql.Data.Firebird.FbCommandBuilder(fbDataAdapter1); fbDataAdapter1.Update(ServiceTable1); fbConnection1.Close(); MessageBox.Show(Saved!); disableItems(); And here r the error message that's prompt out:= An unhandled exception of type 'System.Data.DBConcurrencyException' occured in system.data.dll Addidtional information : COncurrency Violation: the UpdatCommand affected 0 records Hopefully someone can help thx .

Andrzej Wegierski · Answer

Such errors are generated when DataRow status is Modified but there aren't such records in database - searching by primary key. Probable reasons: 1. Error in primary key definition (in DataTable) 2. AcceptChanges() on new record then modification of it and next saving to database Use DataSet.WriteXml(fileXmlWriteMode.WriteSchema) to check what's happend.