Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between datareader and dataset?
- 26 Answers
- 66548 Views
- Microsoft, Noel Infotech, Satyam, Value Labs, I also Faced
- E-Mail Answers
Answer Posted / abhijeet kumar sharma
DataReader is faster for read data.DateReader is readonly
propurse,DataReader read data between reader Read() and
close() methods.When we read data from database help of
DataReader then database connection is must open.
DataSet is disconnected architecture. We store multiple
data at a time in dataset.
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
What is ambient transaction?
What is the difference between Response.Expires and Reponse.ExpiresAbsolute?
What are the steps to connect to a database?
What is the difference between connected and disconnected environment?
If a table contains 20000 records . In a page at each time 100 records to be displayed what are the steps you will take to improve performance? Will you use dataset or datareader?
What is shadow copy?
What is datatable in ado.net?
Why is it important to close an ado.net application?
What does executenonquery () method return?
What is the role of the dataset object in ado.net?
How to maintain the relation between two tables in ADO.NET?
What is the return type of executescalar?
What are the different namespaces used in the project to connect the database? What data providers available in .net to connect to database?
What is the role of data provider in ado.net?
What is the difference in an abstract class and an interface?
