Updating DataTable asynchronously

[John Wood]

I want to update a DataRow asynchronously without it affecting any changes
that have been made by the user. I don't want these changes to be picked up
by the command builder, for example. Is there any way to edit the data in
the DataRow directly without having to go through AcceptChanges and all
that?

Thanks,
John

 

[William Ryan eMVP]

don't call update on the adapter, just take the values of the row and plug
them into a SQL Statement, then fire executeNonQuery.

--
W.G. Ryan MVP Windows - Embedded

http://forums.devbuzz.com
http://www.knowdotnet.com/dataaccess.html
http://www.msmvps.com/williamryan/

 

[John Wood]

Thanks for your reply.

Right that's what I do right now. I was hoping there might be a way to
preserve the command builder functionality AND have the table updated
independently.

I guess not?

 

[William Ryan eMVP]

Don't think so, update calls AcceptChanges so even calling it on just that
row would change it.

--

W.G. Ryan, eMVP

http://forums.devbuzz.com/
http://www.knowdotnet.com/williamryan.html
http://www.msmvps.com/WilliamRyan/
http://www.devbuzz.com/content/zinc_personal_media_center_pg1.asp

 

[Miha Markic [MVP C#]]

Hi John,

You might pass GetChanges() table to adapter.