Data Reader Vs DataSet

Answers were Sorted based on User's Feedback



Data Reader Vs DataSet..

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

Data Reader Vs DataSet..

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

Data Reader Vs DataSet..

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

Data Reader Vs DataSet..

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

Data Reader Vs DataSet..

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

Post New Answer

More ASP.NET Code Interview Questions

How to integrate the regional language in asp.net and c# like Telugu, Hindi etc,. send a sample program

3 Answers   Concept, NIIT, Wipro,


working with fileUpload ?

1 Answers  


Common UI for Multiple web applications. Suppose there are 35 websites using same third party controls.These 3rd party controls are made together that all 35 websites can use these controls.If we put all 3rd party controls and use its dll in 35 websites,only class files will be accessable. But I want to use CSS,images also in all 35 websites. how I can design the N-tier solution for this project.

0 Answers   TCS,


Data Reader Vs DataSet

5 Answers   TCS,


Code for Presenting Parent/Child Data in a Data Grid Row?

0 Answers   TCS,






Code for Getting Information About A File?

1 Answers  


Code for Sending E-Mail with System.Web.Mail?

2 Answers  


Code for Using Keyboard Events?

0 Answers  


Code for a Simple Way to Write XML in .NET (XmlTextWriter)

1 Answers  


How to Export Data to Excel?

4 Answers   Eastcom Systems,


How to get the row index on checking a Checkbox in a ListView

1 Answers   TCS,


Coding for .NET Delegates?

0 Answers  


Categories
  • ASP.NET Code Interview Questions ASP.NET Code (46)
  • VB.NET Code Interview Questions VB.NET Code (9)
  • C Sharp Code Interview Questions C Sharp Code (51)
  • ADO.NET Code Interview Questions ADO.NET Code (8)