hello,
Im trying to move data between a source database and a target database, both databases are on different locations, so i made 2 connection strings.
this is what i have so far:
//removed all the declarations!
Sourceadapter.Fill(SourceDataset)
SourcaDatatable = SourceDataset.Tables(0)
targetdataset = SourceDataset
targetdatatable = SourceDataset.Tables(0)
targetadapter.Update(SourceDataset.Tables(0))
i have made a for loop to test the out put:
For Each targetDatarow In targetdatatable.Rows
Console.WriteLine(targetDatarow("event_id"))
Next
how do i get the data in the target database, im trying to copy 16 tables like this, after that it needs to go row by row on a fixed period..
has anyone got a clue?
thanks in advance
greetz Frank