data adapter

[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

 

[Cor]

Hi Steve,

This is one of the important things in my opinion.

http://msdn.microsoft.com/library/d...aadapterclassacceptchangesduringfilltopic.asp

The rowstate in the dataset has to be as inserted.

I hope this helps,

Cor