C# with database

[hkl]

Hi, I am writing a program with a database ( xxxx.mdb), and the data set is displayed on a DataGrid. I've implemented an Add function to add new record and it's ok. But I can't delete an existing record. The following code is what I've used. this.BindingContext[dbProductSet1, "Products"].RemoveAt(this.BindingContext[dbProductSet1, "Products"].Position); It runs ok, but the record can't be deleted. And, when I later execute: oleDbDataAdapter1.Update(dbProductSet1); An error occurs saying: "Update requires a valid DeleteCommand when passed DataRow collection with deleted rows." Afterward, I added this line and tried again: dbProductSet1.Products.AcceptChanges(); The error message is gone and it seems ok, but in fact the "deleted" record isn't deleted!! Can anyone please give me comments?? Thank you!!!

[Heath Stewart]

Once you do DataSet.AcceptChanges() or DataTable.AcceptChanges(), a DataAdapter no longer sees your changes and therefore doesn't call the required command. DataAdapter() uses DataSet or DataTable.GetChanges() to get a DataSet or DataTable with just the changes and it knows (based on state) which rows have been deleted, inserted, or updated. So, as the error states, you need to assign an OleDbCommand to the DeleteCommand property of the OleDbDataAdapter. That way, when it runs across a record that has been marked for deletion, it'll call the appropriate SQL statement to delete the record. "Well, I wouldn't say I've been missing it, Bob." - Peter Gibbons