Update and AcceptChanges

  • Thread starter Thread starter perspolis
  • Start date Start date
P

perspolis

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..
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't understand the purpose of AcceptChanges on a DataView 1
Need help with C# DataSets 4
DataBase doesn't AcceptChange 2
DataRow EndEdit and AcceptChanges 1
RowState not updating 13
update with textboxes 1
Updates not made in database 2
Update and AcceptChanges 4

Back
Top