DbDataAdapter.Update does nothing

26 Jun 2006 1:39 PM

Olivier Matrot

Hello,

I'm having trouble inserting data in a table.
Basically, I'm adding a datarow to a datatable that was populated from the
datasource with an adapter.
Before calling the Update command, the datatable is added a new row
(RowState for this new row = Added).
After calling the Update Method, rowstate becomes Unchanged and no exception
is thrown...
I'm trying to understand this behavior. Any help appreciated.
TIA.

26 Jun 2006 1:52 PM

Olivier Matrot

In fact it does something !
I'm using SQL Profiler to see what's going on underneath. I was only
catching TSQL events... No luck, the dataadapter is using RPC !!! Using the
(default) template, I could see now that everything is fine !!!

Show quote

"Olivier Matrot" <olivier.matrot.rte@online.nospam> wrote in message
news:ewHdrXSmGHA.4696@TK2MSFTNGP05.phx.gbl...
> Hello,
>
> I'm having trouble inserting data in a table.
> Basically, I'm adding a datarow to a datatable that was populated from the
> datasource with an adapter.
> Before calling the Update command, the datatable is added a new row
> (RowState for this new row = Added).
> After calling the Update Method, rowstate becomes Unchanged and no
> exception is thrown...
> I'm trying to understand this behavior. Any help appreciated.
> TIA.
>