|
|
|
start date: Mon, 30 Jul 2007 13:08:26 -0500,
posted on: microsoft.public.dotnet.framework.adonet
back
| Thread Index |
|
1
Flomo Togba Kwele am
|
|
2
Earl am
|
|
3
Flomo Togba Kwele am
|
Datatable Update method not updating
I have a dataset containing a datatable. Everything was working OK. Then I changed the definition
of one of the columns from not null to nullable. Now when I update the adapter, the change is not
being written to the DB.
Just before the update, I looked at the data in the datatable by walking through the datarows, and
it contains the expected value for the row and column I'm interested in. The very next statement is
the Update.
What could be causing this? What tools can I use to diagnose this further?
Thanks, Flomo
--
Date:Mon, 30 Jul 2007 13:08:26 -0500
Author:
|
Re: Datatable Update method not updating
If you don't want to manually dig through the generated code, simply
recreate your command objects for insert and update.
"Flomo Togba Kwele" <Flomo@community.nospam> wrote in message
news:xn0f9bci37qnnj000@news.giganews.com...
>I have a dataset containing a datatable. Everything was working OK. Then I
>changed the definition
> of one of the columns from not null to nullable. Now when I update the
> adapter, the change is not
> being written to the DB.
>
> Just before the update, I looked at the data in the datatable by walking
> through the datarows, and
> it contains the expected value for the row and column I'm interested in.
> The very next statement is
> the Update.
>
> What could be causing this? What tools can I use to diagnose this further?
>
> Thanks, Flomo
> --
>
Date:Sat, 4 Aug 2007 00:34:23 -0400
Author:
|
Re: Datatable Update method not updating
I gave up on this and reverted to an older version which worked.
I am sorry I didn't have time to try the suggestions, but I do thank you for them.
Flomo
--
Date:Wed, 08 Aug 2007 15:45:51 -0500
Author:
|
|
|