how do you read an entire database to a dataset

  • Thread starter Thread starter AboutJAV
  • Start date Start date
A

AboutJAV

Hi,

I read alot of articles on how to read 1 table to a dataset.
How do you read and entire database to a dataset, do a fill, and update
it after modification.

Thanks
 
(e-mail address removed) wrote in @e3g2000cwe.googlegroups.com:
I read alot of articles on how to read 1 table to a dataset.
How do you read and entire database to a dataset, do a fill, and update
it after modification.
Click to expand...

How large is your database? It's generally a bad idea to read the entire
database into a dataset due to the amount of memory use.

If you need to make modifications, either do it in SQL or in batches.
 
I agree.....VERY bad idea. So bad in fact DONT do it. Whatever you are doing
you don't need to read your whole db into a dataset.
 
Back
Top