471,610 Members | 1,331 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,610 software developers and data experts.

Update and AcceptChanges

Hi all
when I call Update method of SqlDataAdaptor it calls AcceptChanges
automatically.is it possible to prevent calling AcceptChanges??
I know I can use GetChanges method but because in my table the primary key
is auto number when I merge back the changes, it shows the channges twice in
DataGrid.
thanks in advance..
Dec 11 '05 #1
1 1937
perspolis,

The only way I can think of doing this would be to actually copy the
data set (using GetChanges) and then perform the update on that. You would
then have to merge the changes back with the original data set.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"perspolis" <re*****@hotmail.com> wrote in message
news:uu*************@tk2msftngp13.phx.gbl...
Hi all
when I call Update method of SqlDataAdaptor it calls AcceptChanges
automatically.is it possible to prevent calling AcceptChanges??
I know I can use GetChanges method but because in my table the primary key
is auto number when I merge back the changes, it shows the channges twice
in
DataGrid.
thanks in advance..

Dec 11 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Shahar | last post: by
6 posts views Thread by John J. Hughes II | last post: by
3 posts views Thread by Justin | last post: by
1 post views Thread by !!bogus | last post: by
2 posts views Thread by Calvin KD | last post: by
3 posts views Thread by Wanda | last post: by
1 post views Thread by Tony Papadimitriou | last post: by
8 posts views Thread by Zorpiedoman | last post: by
15 posts views Thread by Scotty | last post: by
3 posts views Thread by C a r l o s A n t o n i o | last post: by
1 post views Thread by XIAOLAOHU | last post: by
reply views Thread by CCCYYYY | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.