Concurrency error when deletinga record from datagridview

[artteam]

Hi All,
I get an error when I try to delete a record from the datagridview, which says Concurrency violation:the DeleteCommand affected 0 of the expected 1 records .
Could someone please let me know which statement is causing this exception.

I have made use of wizards to establish connection and generate the datagridview on to my form rather than writing code.

Thanks in advance.

[RedSon]

Hi All,
I get an error when I try to delete a record from the datagridview, which says Concurrency violation:the DeleteCommand affected 0 of the expected 1 records .
Could someone please let me know which statement is causing this exception.

I have made use of wizards to establish connection and generate the datagridview on to my form rather than writing code.

Thanks in advance.

The use of wizards should have produced some code. We have no idea what statement is causing the exception unless you post it. So why don't you post it and we can take a look. Also please highlight the line(s) that are causing the error.

[artteam]

The use of wizards should have produced some code. We have no idea what statement is causing the exception unless you post it. So why don't you post it and we can take a look. Also please highlight the line(s) that are causing the error.

The following statement is written by us which is calling the system generated code and it is the one which is raising the exception.

this.inventoryTableAdapter.Update((ArtStoreDataSet .InventoryDataTable)this.artStoreDataSet.Tables["Inventory"]);

System Generated Code: in bold
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private System.Data.OleDb.OleDbDataAdapter Adapter {
get {
if ((this._adapter == null)) {
this.InitAdapter();
}
return this._adapter;
}
}

Thank you in advance.