All,

Is there a way to add a new row to a dataset but make it think it is
changed data and should perform an "Update" rather than insert when the
update() method is called?

Thanks,

JamesK

Try adding the row, then calling AcceptChanges() on the row, then modifying
one of the columns.

--
Regards,

Tim Ellison
"-=JLK=-" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> All,
>
> Is there a way to add a new row to a dataset but make it think it is
> changed data and should perform an "Update" rather than insert when the
> update() method is called?
>
> Thanks,
>
> JamesK
>
>

My concern there would be the type of update statement generated. Would it
try to include as "original" column data the column as it looked before the
second modification? If the update statement includes only the Primary Key
it would be OK but I thought it tried to include all changed columns by
default?

Thanks,

James K.

"Tim Ellison" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Try adding the row, then calling AcceptChanges() on the row, then
modifying
> one of the columns.
>
> --
> Regards,
>
> Tim Ellison
> "-=JLK=-" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > All,
> >
> > Is there a way to add a new row to a dataset but make it think it is
> > changed data and should perform an "Update" rather than insert when the
> > update() method is called?
> >
> > Thanks,
> >
> > JamesK
> >
> >
>
>