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.

"Kristian" <(E-Mail Removed)> wrote in message
news:8FBB858B-284C-4CE2-BFD4-(E-Mail Removed)...
> Hello,
> Could anyone advice on the best method to collect all data from a database
> to a dataset?
> Thanks in advance,
> kk

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

"Marina" wrote:

> 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.
>
> "Kristian" <(E-Mail Removed)> wrote in message
> news:8FBB858B-284C-4CE2-BFD4-(E-Mail Removed)...
> > Hello,
> > Could anyone advice on the best method to collect all data from a database
> > to a dataset?
> > Thanks in advance,
> > 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.
__________________________________

"kk" <(E-Mail Removed)> wrote in message
news:EBD44372-3B7C-4277-A089-(E-Mail Removed)...
> 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
>
> "Marina" wrote:
>
>> 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.
>>
>> "Kristian" <(E-Mail Removed)> wrote in message
>> news:8FBB858B-284C-4CE2-BFD4-(E-Mail Removed)...
>> > Hello,
>> > Could anyone advice on the best method to collect all data from a
>> > database
>> > to a dataset?
>> > Thanks in advance,
>> > kk
>>
>>
>>

You should use DTS to move data between databases, not ADO.NET.

"kk" <(E-Mail Removed)> wrote in message
news:EBD44372-3B7C-4277-A089-(E-Mail Removed)...
> 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
>
> "Marina" wrote:
>
>> 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.
>>
>> "Kristian" <(E-Mail Removed)> wrote in message
>> news:8FBB858B-284C-4CE2-BFD4-(E-Mail Removed)...
>> > Hello,
>> > Could anyone advice on the best method to collect all data from a
>> > database
>> > to a dataset?
>> > Thanks in advance,
>> > kk
>>
>>
>>