S
steve
i'm calling a web service that returns a dataset. i'm trying, but failing,
to use that dataset to populate a local sql server table. the table names
between the two are different but their structures are the same.
here's pseudo-code:
dim mytable as string = "otherstuff"
dim mydataset as dataset = mywebsvc.getstuff()
dim myadapter as new sqldataadapter()
cmd.commandtext = "insert into stuff values (?, ?, ?)"
myadapter.insertcommand = cmd
myadapter.update(mydataset, mytable)
any input is appreciated.
tia,
steve
to use that dataset to populate a local sql server table. the table names
between the two are different but their structures are the same.
here's pseudo-code:
dim mytable as string = "otherstuff"
dim mydataset as dataset = mywebsvc.getstuff()
dim myadapter as new sqldataadapter()
cmd.commandtext = "insert into stuff values (?, ?, ?)"
myadapter.insertcommand = cmd
myadapter.update(mydataset, mytable)
any input is appreciated.
tia,
steve