dataset 2 database

[Sjaakie Helderhorst]

Hello,

I have this webservice which receives a dataset.
This dataset contains a table 'playlist'. This table is identical to a table
in my SQL Server (identical cell-names).
Is it possible to do a 'simple' INSERT command and transfer all data from
this dataset to the database? Or need I loop through al records in the
dataset? Since it is possible to fetch to a dataset using a datadapter, it
seems obvious to me to insert into the database likewise.

I've been searching for some docs all afternoon (Google) without any luck.

Thanks in advance

[Sjaakie Helderhorst]

"Suresh" <an*******@discussions.microsoft.com> schreef in bericht
news:28**********************************@microsof t.com...

SqlDataAdapter.Update(....) method will do what you are trying to do. Check out this sample.
http://samples.gotdotnet.com/quickst...ataFromDB.aspx
HTH,
Suresh.

----- Sjaakie Helderhorst wrote: -----

Is it possible to do a 'simple' INSERT command and transfer all data from this dataset to the database? Or need I loop through al records in the dataset? Since it is possible to fetch to a dataset using a datadapter, it seems obvious to me to insert into the database likewise.

Thanks Suresh,
This method requires a SELECT first, then merge the datarows (which I
manually have to fetch from the dataset) and then update the database. So I
think doing a INSERT right away would be a faster solution... but I'll give
it a try, since things don't always are the way they look...