Member Avatar for jemz

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?

  • 3 Contributors
  • 3 Replies
  • 112 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by M.Waqas Aslam
Member Avatar for khair.ullah

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.

Member Avatar for jemz

Hi,so which is better to use?

Member Avatar for M.Waqas Aslam

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.