Data Reader Vs DataSet
- 5 Answers
- 7334 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 we implement the paypal in my website and how we make a payment through Credit Card.
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.
how to create a search bar which access data from various websites and retrieves the data
What is the code of Password Recovery or Forget your password? Plz tell in c # language.
Code for Communicating over Sockets?
how to upload a photo? i need to use it in a matrimonial applicaton...
Code for Using Keyboard Events?
Code for Document Validation in XML.NET?
How we use ajax in asp.net through javaScript. Please givee me an example.
how can we close a web page in asp.net without using jscript?
How to Bind Nested XML to a Repeater Control with Container.DataItem?
ArrayList declaration in .net
ASP.NET Code 
