Is there a way to replace a datatable in a typed dataset?

[Dave]

Maybe I'm not going about this the right way. I have a dataset with 3
tables in it. I'd like to cache 2 of those data tables instead of the
whole dataset. What I thought I would do is create a typed datatable
and set it to the value of the cached datatable. Then, if it "is
nothing", I fill the datatable in the dataset. That all works fine.
The problem comes when it does find the data table. How do I replace
the empty datatable in the typed dataset with the one from the cache?

Thanks for your help.

Big Dave

 

[David Browne]

Maybe I'm not going about this the right way. I have a dataset with 3
tables in it. I'd like to cache 2 of those data tables instead of the
whole dataset. What I thought I would do is create a typed datatable
and set it to the value of the cached datatable. Then, if it "is
nothing", I fill the datatable in the dataset. That all works fine.
The problem comes when it does find the data table. How do I replace
the empty datatable in the typed dataset with the one from the cache?

Use DataSet.Merge to load the cached data into a new DataSet.

David

 

[Dave]

Perfect, thank you very much for your help!

Big Dave