Difference between datareader and dataset?
- 26 Answers
- 63561 Views
- Microsoft, Noel Infotech, Satyam, Value Labs, I also Faced
- E-Mail Answers
Answer Posted / jayeshwaree
datareader:
*connected enviornment
*reads one row at a time. By using Read() we can read the
read records of one row
*used to retrieve data as it returns a result set in a read
only and forward only mode
dataset:
*disconnected enviornment
*it is used as a container to hold one or more tables with
constraints and relations
*to update the changes made in dataset we need a data
adapter and we need to call the Update() method
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is a control toolbox?
Why is stored procedure used in ado.net?
What is ole used for?
What does ado stand for?
What is concurrency? How will you avoid concurrency when dealing with dataset? (One user deleted one row after that another user through his dataset was trying to update same row. What will happen? How will you avoid the problem?)
What is the use of SqlCommand object?
Does ado.net use odbc?
What is the meaning of object pooling?
How to retrieve the user id which is provided while windows authentication?
How to aggregating data across related tables?
Define executenonquery?
What is read only and forward only in ado.net?
What do you know about ado.net's objects?
What is serialization and de-serialization in .net? How can we serialize the dataset object?
What are the drawbacks of using ado.net?
