Difference between datareader and dataset?
- 26 Answers
- 63239 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
Does sqlclient and oledb class share the same functionality?
What are the advantage of ado.net?
How to work with disconnected data - the dataset and sqldataadapter?
What is the full form of ado.net?
What are the steps to connect to a database?
What is oledb driver?
What is sqldatareader?
Describe connection object in ado.net
What is the role of the dataset object in ado.net?
What is DataReader Object?
Explain advantages of ado.net?
Give an example that shows how to execute a stored procedure in ado.net?
What providers does Ado.net uses?
What is openrowset?
What are the ado.net objects?
