Multiple datasets

dave_sky
dave_sky used Ask the Experts™
on
Software VS2005 & sql server 2005:

I have filled a dataset in a windows application to a point where I cannot add more to the dataset. (Out of storage).

Is there a way I can create another dataset that will add to the functions of the first dataset?

Thanks for your help!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Fernando SotoRetired
Distinguished Expert 2017

Commented:
I do not know what you mean by this, " I cannot add more to the dataset. (Out of storage).", If you are getting an exception thrown please post the complete message an inner exception and on what line it happens on and yes the code please.
Top Expert 2015
Commented:
Datasets are huge beasts when you try to get all the data in memory. Limit the data that you retrieve to what you really need.

Author

Commented:
I found that having a lot of shortcuts on monitors was robbing memory...

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial