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?

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.

Hi,so which is better to use?

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


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.