Editing data in a grid and updating error

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 .

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Andrzej Wegierski22y ago
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(file,XmlWriteMode.WriteSchema) to check what's happend.