sqldatareader or sqldatadapter

I have a Win app which gets data from sql and write to formfill in pdf using ActivePDF. Total columns is 50. Is it better to use sqldatareader to read each row at a time (per each account) and fille out labels, create directory to store them or use sqldataadapter, fill it to datatable instead and then loop them?  This could be up to 1000 or 2000 accounts.
VBdotnet2005Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

CodeCruiserCommented:
Both would be fine as the data is not huge. Would really depend on the structure of your code. You would be looping in both cases. If the data is being loaded from a remote server then I would be inclined to use a datatable.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
VBdotnet2005Author Commented:
Would you perfer to use sqldatareader or sqldataadapter ?
0
CodeCruiserCommented:
I think I tried to answer that question in my comment above.
0
Jacques Bourgeois (James Burger)PresidentCommented:
When you do not need to update the data afterward, the SqlDataReader is usually a better choice. It is faster and requires less resources. A collection or dictionary usually also takes up less resources than a DataTable.

But as always, a lot of factors come into account, so the only way to be sure is to test both.

I would bet on the DataReader though.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic.NET

From novice to tech pro — start learning today.