DA Update Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I realize this is a broad ADO .Net question but i thought I'd give it a shot
because i can't solve it

When my DG opens and I select a row for deletion everything works fine. If
I add a row through a separate Add Form class that returns a merged DS and
try to delete the row I just added from the DG the DA.update(DS) gives an
exception ("deletecommand affected 0 records"). The Row State of the row is
"Delete" and the DS haschanges(). i think the total row counts of the DS and
DG are correct

Any Ideas? I'm possessed by it.

Steve
 
Hi Steve,

Update notifies you that it hasn't made any update while it should made
them.
This means that UPDATE sql statement failed because of WHERE condition.
You should check what your DA.UpdateCommand.CommandText does.
 
Back
Top