Difference between datareader and dataset?
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
How to pass multiple tables in datasets simultaneously?
How to check if a datareader is closed or opened? IsClosed()
Which object needs to be closed?
What does executequery return?
What is variable view?
What are all the different authentication techniques used to connect to MS SQL Server?
How do you update database through dataset?
What are the Features of a dataset
What are different layers of ADO.Net?
How to aggregating data across related tables?
What is the difference between DataReader and DataSet in ADO.NET?
Why is ADO.NET serialization slower than ADO ?
What is read only and forward only in ado.net?
What does executereader return?
Difference between sqlcommand and sqlcommandbuilder?