All tables from a db to one dataset

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
Could anyone advice on the best method to collect all data from a database
to a dataset?
Thanks in advance,
kk
 
I would advise you to not do this.

If you will do it anyway, there is really no other way then to have select
statements for each table, and call Fill on a dataadapter.
 
OK,
It's not for the application, it's to move data from old to new...

But there must be a way to use commandbuilder huh?
kk
 
Worse yet. Use DTS or BCP to move the data. ADO makes a terrible bulk-data
transport mechanism.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Back
Top