Hi, I am stuck on this two sqldatadapater and sqldatareader,we can display records in listview by using this sqldatadapter and sqldatareader.my question which is more effecient and secured to use?does this two matters in populating data in database?
jemz
-1
Master Poster
Recommended Answers
Jump to Postdataadapter get all data and put it in dataset at once ,but datareader get data line by line . so what i think dataadapter is faster then datareader.
one more thing in datareader data is only readonly .
here is a link please visit it for more information
All 3 Replies
khair.ullah
-2
Junior Poster in Training
Data Adapter Object can put tabld into data set as a whole. While Data Reader can put data in data set by adding one by one row.
jemz
-1
Master Poster
Hi,so which is better to use?
M.Waqas Aslam
67
Posting Pro in Training
Featured Poster
dataadapter get all data and put it in dataset at once ,but datareader get data line by line . so what i think dataadapter is faster then datareader.
one more thing in datareader data is only readonly .
here is a link please visit it for more information Click Here
Regards
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.