Update Table from another table

Y

Yakimo

Hi

I am trying to append some records form tmpSource to tmpDest table using
datasets
My setup is the following:
- daSource - dataadapter for source table
- daDest - dataadapter for Dest table (containing select, update, delete and
append commands)
- dsSourceDest - generated dataset containing both Source and Dest table

I want ot read data from tmpSource and put it in tmpDest like that:

daSource.Fill(DsSourceDest1)MsgBox(DsSourceDest1.Tables("tmpSource").Rows.Co
unt)
 

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

Update Table from another Table 3
copying data from one dataset into another 3
Dataadabter update command throws error 4
Update fails with Primary Key Violation 1
update database from dataset 2
Update and append records in one table based on shared primary key 4
Using CommandBuilder to update an Access table from a DataGridView 2
getting table adapter return values from stored procedures? 1

Top