Hi

How can I insert a dataset into an sql table?

Thanks

Regards

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi
>
> How can I insert a dataset into an sql table?
>
> Thanks
>
> Regards
>
>

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi
>
> How can I insert a dataset into an sql table?
>
> Thanks
>
> Regards
>
>

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Hi
>>
>> How can I insert a dataset into an sql table?
>>
>> Thanks
>>
>> Regards
>>
>>
>
>