Interested to Buy Any Domain ? << Click Here >> for more details...
Data Reader Vs DataSet
- 5 Answers
- 8846 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mani
Dataset disconnected architecture
dataset contains datatable
datatable contains data rows and data columns.
Data reader connected architecture
data reader is read only, forward only stream of data from
database.
| Is This Answer Correct ? | 5 Yes | 2 No |
Answer / gajendra
data reader reads data and store it in table.
while dataset contains one or more datatable within itself.
datasets are connection less while datareader required
connection to read data.
| Is This Answer Correct ? | 8 Yes | 6 No |
Answer / rahul shukla
DataReader
Datareader is like a forward only recordset. It fetches one
row at a time so very less Network Cost compare to
DataSet(Fetches all the rows at a time). DataReader is
readonly so we cannot do any transaction on them. DataReader
will be the best choice where we need to show the data to
the user which requires no transaction ie reports. Due to
DataReader is forward only we cannot fetch the data
randomly. .NET Dataproviders optimizes the datareaders to
handle the huge amount of data.
Data Set
Data Set is always a bulky object that requires lot of
memory space compare to Data Reader. We can say the data set
as a small database coz it stores the schema and data in the
application memory area. DataSet fetches all data from the
data source at a time to its memory area. So we can traverse
through the object to get required data like qureying database.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / ramu
In ADO.NET Two types of Architectures are there one is connection oriented another one is disconnected architecture.
DataReader,DataSet Both are frontend objects to querying on Datasource,both objects operation is similar but small difference is there
DataReader used in Connection oriented and it stores one table at a time ,it reads data from datasourse forward direction only,it can't work for backward read and one more thing is Datareder is readonly.
Dataset used in disconnected oriented and it stores more than one table,it read/write date from database both forward and backward directions.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / puneet
datreader reads the data only not manipulate the data. but
dataset manipulate the data. its true dataset store the data
of multiple tables
| Is This Answer Correct ? | 4 Yes | 6 No |
how to upload an excel in c# ASP.Net?
hold checkbox values
where is assembly are store
ArrayList declaration in .net
Code for Using Keyboard Events?
Code for Document Validation in XML.NET?
Data Reader Vs DataSet
How to integrate the regional language in asp.net and c# like Telugu, Hindi etc,. send a sample program
3 Answers Concept, NIIT, Wipro,
How to Create Scrollable Micro Windows?
working with fileUpload ?
how can we close a web page in asp.net without using jscript?
how to design a ListView control?
ASP.NET Code 
