c@ 2008 express - datagridview will not remove the record from database even though it disappears from DGV temporarily

Question

Can someone help me understand why if I select a row in the the DGVand delete it, it disappears but when I close my app and reopen (or refresh the databindings) it pops back up.

I have a customers table with relationships and the only one that is giving me this problem is one that I created in the same way as the others.

Modifications to this DGV give me the same problem.

Any help greatly appreciated

Thanks in advance

Manuel B · Answer

Hi Problem solved. (thanks anyway for your post). Discovered that the tableadaptermanager was not linked (in properties) to that specific table's tableadapter and so when I used to hit the save button on the binding navigator the actual tableadaptermanager.updateall was giving me that situation. Nothing wrong with the DGV simply no changes saved. Best Regards

makando kabila · Answer

It could be a lot of things. Is your DGV bound to a datatable in a dataset. If so are you calling the Update method of the table adapter on the datatable/dataset? before reloading Are you calling the table.AcceptChanges() method before trying to update? On the database side are there any constraints that would prevent deletion? If you provide with a couple of additional details then I can advise you better.