Link to home
Start Free TrialLog in
Avatar of VBdotnet2005
VBdotnet2005Flag for United States of America

asked on

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.
ASKER CERTIFIED SOLUTION
Avatar of Nasir Razzaq
Nasir Razzaq
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of VBdotnet2005

ASKER

Would you perfer to use sqldatareader or sqldataadapter ?
I think I tried to answer that question in my comment above.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial