row doesn't get deleted
-
Hi row adding (after adding + saving, reloading the form) is OK to 1 of my table but delete is not... Here's what I've done: since DeleteCommand didn't exist to that table I defined a simple one (at dataset designer mode to the tableadapter):
DELETE FROM Felhaszn_Egyeb
WHERE (TetelArId = @TetelArId) AND (EgyebId = @EgyebId) AND (Mennyiseg = @Mennyiseg)similarly UpdateCommand is defined as follows:
UPDATE Felhaszn_Egyeb
SET TetelArId = @TetelArId, EgyebId = @EgyebId, Mennyiseg = @Mennyiseg
WHERE (TetelArId = @Original_TetelArId) AND (EgyebId = @Original_EgyebId)upon the user clicks the delete button, the bindingsource.removecurrent() & bindinsource.endedit() & [dataset].acceptchanges() are invoked row is deleted from the datagridview upon user clicks save the well known invoked (thistableadapter.update(thisdataset.thisdatatable) upon reloading the form it still fills the table with 1 row, which shouldn't be there thx for your thread...g