Update Remote DB from Local Table?

[Vandy02]

I pulled data from a remote database and filled a datatable with the results through a data adapter.
I then update the locale data using dataview with a datagrid...

How do I send these changes back to the remote db?
Note, when I pull the data from db it is in a table and not a dataset as I was unable to get the dataview to use a dataset table.

My dataview is DV and table is DTEmp.
I am wanting to update table EMP within the remote db.

Thanks....

 

[chrissie1]

You will need to write your own insert and update statements or create a second dataadpter that refers to the other table with all the same fields and then do an update on that. Not sure if that will really work.

Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting