Copy one dataset to another

[arrian]

Here's the issue:

I have Crystal Reports built using XSD files in the project. I have datasets built in code that will contan data that I need to put into the typed datasets of the project. Only problem is I'm not sure how to do this, other than 1 row at a time. There is potentially a LOT of data that's going to need to be moved from one dataset into the other, and this can take a while if it's one row at a time. And I can't just move the table, as I need the data to show up in the Crystal Report. Any ideas?

 

[jebenson]

Use the Copy method of the original dataset:

Dim ds1 As DataSet
Dim ds2 As DataSet

'code to fill ds1 here

ds2 = ds1.Copy


I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson

 

[arrian]

Wow... I'm kind of dissapointed that I didn't figure that out... That's rediculously easy... Thanks!

 

[arrian]

Ok, the problem I'm having is the datasets that need to recieve the data are typed datasets. How do I get the data from a dataset filled from my Access DB into the typed dataset? The copy command doesn't seem to work.

 

[Mastakilla]

Can't you fill the typed dataset the same way you filled the first dataset?

 

[arrian]

I had hoped I could, but that doesn't seem to work... I was filling the other dataset with a data adapter, and that doesn't seem to work... I actually did find a way to do this, I think... Other things aren't working, so I'm not 100% sure this works.

ds1.Merge(ds2)

 

[jebenson]

I was filling the other dataset with a data adapter, and that doesn't seem to work

Does it fail with an error message? What is the problem?


I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson