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.

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.

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.

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.

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

Give coding for Exception Handling Techniques in ASP.NET?

3 Answers   Microsoft,

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

1 Answers  

what is the value that reside in a hidden field when no value is assigned to it?how it can be used in a if statement??

1 Answers  

i have a gird with columns all are coming from database,this will bind in item templete in gridview as textboxex.and i have button below named Update.i want to update all the records in the grid,but if user change the value of one textbox,what is the easy way 2 do this

0 Answers   Crompton Greaves,

Coding for .NET Delegates?

0 Answers  

How we use ajax in asp.net through javaScript. Please givee me an example.

0 Answers  

Give coding for Implementing a Fixed GridView Header in ASP.NET?

1 Answers  

How to send e-mail from an ASP.NET application?

16 Answers   DataPoint, Infosys, Persistent, Radar, TCS, Wipro,

what is software testing

1 Answers   TCS,

Code for Getting Information About A File?

1 Answers  

Code for Creating a Form Using PlaceHolder Controls?

0 Answers   Arena, JSA,

how to create a search bar which access data from various websites and retrieves the data

0 Answers