Multiple Data Adapters

[Seattle Matt]

I am a newbie.

I was wondering if I should use a seperate dataadapter
for each of the tables I am accessing in a database.
Currently I am, but as I understand more it seems that
only one dataadapter is necessary per database and i can
create multiple datasets and datatables with those to
bring the tables into my program. Any Suggestions/
Explainations appreciated.

Thanks,
Matt

 

[William Ryan eMVP]

In my experience, Yes, it's probably easier. Technically, you can just
switch the commands around, but that's a big pain and if you just use a
clear naming convention, everythign will be clear and logically seperated.

HTH,

Bill

www.devbuzz.com
www.knowdotnet.com

 

[Seattle Matt]

Thanks, I just wanted to know know if I'm doing this
totally wrong


Matt