Inserting a dataset

[John]

Hi

How can I insert a dataset into an sql table?

Thanks

Regards

[Chris Johnson]

Start here with the MSDN information to see if that helps you. It may at
least narrow your question when, after trying the examples, you run into any
stumbling blocks.

SQL DataAdaptor:
http://msdn.microsoft.com/library/de...classtopic.asp

Let us know if you have further questions!
chrisj

"John" <Jo**@nospam.infovis.co.uk> wrote in message
news:eW**************@TK2MSFTNGP09.phx.gbl...

Hi

How can I insert a dataset into an sql table?

Thanks

Regards

[W.G. Ryan - MVP]

That's going to depend on how the datatables inside the dataset were
populated. The key is rowstate and if it's not changed (Modified, Deleted,
Added) then you're going to have to loop through the rows and fire your sql
statements based on those values.

Where is the data coming from in the first place? DTS might be a much better
way to go about doing this if at all possible.
"John" <Jo**@nospam.infovis.co.uk> wrote in message
news:eW**************@TK2MSFTNGP09.phx.gbl...

Hi

How can I insert a dataset into an sql table?

Thanks

Regards

[John]

The dataset would have new data only i.e. no conflict with existing keys and
also it only needs to be appended. The dataset insert is to be done within a
webmethod which gets the dataset as parameter from the calling procedure.

Thanks

Regards

"W.G. Ryan - MVP" <Wi*********@nospam.gmail.com> wrote in message
news:el**************@TK2MSFTNGP09.phx.gbl...

That's going to depend on how the datatables inside the dataset were
populated. The key is rowstate and if it's not changed (Modified,
Deleted, Added) then you're going to have to loop through the rows and
fire your sql statements based on those values.

Where is the data coming from in the first place? DTS might be a much
better way to go about doing this if at all possible.
"John" <Jo**@nospam.infovis.co.uk> wrote in message
news:eW**************@TK2MSFTNGP09.phx.gbl...

Hi

How can I insert a dataset into an sql table?

Thanks

Regards