Moving data from one dataset to another

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

What is the easiest way to move data from one dataset to another?

I have a web service that returns a dataset from a datasource. I then want to move all the data in one datatable in that dataset to another datatable in another dataset. (For instance, a table of Employees is returned in the web service dataset. I then want to move all those Employees into an Employees datatable in my local dataset.)

The first way that comes to mind is to use a loop - read and move each record individually. I'm wondering if there is a single command that will do it without a loop. (I'm programming in VB.NET, so the VB version of the command would be appreciated if possible, although I can cross-reference the C# version myself.)

Thanks for any assistance.
.

Relevant Pages

  • Re: Moving data from one dataset to another
    ... I have a web service that returns a dataset from a datasource. ... a table of Employees is returned in the ... The first way that comes to mind is to use a loop - read and move each ... I'm wondering if there is a single command that will ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Best practice to support resume in an orchestration
    ... resume this once the web service is availabile. ... Boolean variables in an orchestration) so that the actions in the loop will ... there), and suspend the orchestration. ...
    (microsoft.public.biztalk.general)
  • Copy DataSet questions
    ... I am about to start developing some code that will take a complex DataSet ... service as a completely new entity so any primary keys that are autonumbers ... Loop through all the tables and rows and insert them into the new DataSet ... If I send this dataset into my web service I'm hoping that it is recognized ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Help with Web Service Exception Handling
    ... I thought I understood the looping idea, ... I placed the web service call and the exception block into a loop ...
    (microsoft.public.biztalk.general)
  • Re: Help with Web Service Exception Handling
    ... scope is inside a loop shape and you set a variable to indicate to the loop ... I'm testing this by renaming my web service. ... When I look in the Admin ...
    (microsoft.public.biztalk.general)