Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between datareader and dataset?
- 26 Answers
- 67579 Views
- Microsoft, Noel Infotech, Satyam, Value Labs, I also Faced
- E-Mail Answers
Answer Posted / madhavi
DATA Reader
The DataReader has a defined set of operations that revolve
around its connected, forward-only, read-only nature (the
read-only DataReader is also known as the firehose cursor of
ADO.NET). A DataReader is a stream of data that is returned
from a database query. When the query is executed, the first
row is returned to the DataReader via the stream. The stream
then remains connected to the database, poised to retrieve
the next record. The DataReader reads one row at a time from
the database and can only move forward, one record at a
time. As the DataReader reads the rows from the database,
the values of the columns in each row can be read and
evaluated, but they cannot be edited.
DATA Adapter
The DataSet is the main data storage tool in the ADO.NET
disconnected architecture. Unlike the DataReader, the
DataSet is not connected directly to a database through a
Connection object when you populate it. Instead, to fill a
DataSet from a database you first create a DataAdapter
object (such as a SqlDataAdapter) for the provider and
associate it with a SqlConnection object. Then the
SqlDataAdapter can broker the data retrieval for the DataSet
by issuing a SqlCommand against the database through the
SqlConnection, retrieving the data, and filling the DataSet.
You can think of the SqlDataAdapter as a bridge between the
connected and disconnected objects. One of its purposes is
to serve as the route for a rowset to get from the database
to the DataSet. For example, when the SqlDataAdapter's Fill
method is executed it opens its associated SqlConnection
object (if not already open) and issues its associated
SqlCommand object against the SqlConnection. Behind the
scenes, a SqlDataReader is created implicitly and the rowset
is retrieved one row at a time in succession and sent to the
DataSet. Once all of the data is in the DataSet, the
implicit SqlDataReader is destroyed and the SqlConnection is
closed.
| Is This Answer Correct ? | 40 Yes | 10 No |
Post New Answer View All Answers
Explain the dataadapter class in ado.net?
How would you connect to database using .NET?
What DataReader class do in ADO.NET ?
differences between ADO and ADO.NET
Which is better entity framework or ado.net?
What are the different execute methods of Ado.Net?
How can I retrieve two tables of data at a time by using data reader?
Why ca not we use multiple inheritance and garbage collector paralelly in .net?
What is the difference between a datareader and a dataset?
What are the several execute methods of ado.net?
Explain the namespaces in which .net has the data functionality class.
List the 4 common ado.net namespaces?
Which components of a data provider is used to retrieve, insert, delete, or modify data in a data source?
What are the parameters that control most of connection pooling behaviours?
How do you connect to sql server database without using sqlclient?
