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.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/
SLODUG - Slovene Developer Users Group www.codezone-si.info

"Steve B." <(E-Mail Removed)> wrote in message
news:43B6F098-3D94-4494-A0E4-(E-Mail Removed)...
>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