Difference between datareader and dataset ?

Answers were Sorted based on User's Feedback



Difference between datareader and dataset ?..

Answer / j_baghla

Datareader is used for readonly-forward only data.We can't
update the database by datareader.We can store more than
one resultset in the datareader so we can't create the
relations between the tables.There is no record pointer to
read the data in the datareader.We can read the datat from
the datareader by using reader method.

Dataset can contain more than one table and we can create
relationships among those tables.we can read the data by
for each loop.Dataset can contain data from different
datasources like oracle,sqlserver,access etc.

Is This Answer Correct ?    3 Yes 1 No

Difference between datareader and dataset ?..

Answer / jagadeesh naidu

Datareader is used for readonly-forward only data.We can't
update the database by datareader.We can store more than
one resultset in the datareader so we can't create the
relations between the tables.There is no record pointer to
read the data in the datareader.We can read the datat from
the datareader by using reader method.

Dataset can contain more than one table and we can create
relationships among those tables.we can read the data by
for each loop.Dataset can contain data from different
datasources like oracle,sqlserver,access etc.

Is This Answer Correct ?    1 Yes 0 No

Difference between datareader and dataset ?..

Answer / anita

datareader is component of connected environment is used to
retreive the value from datasource ,on the otherhand dataset
is the component of disconnected environment.it contain
datatable s .

Is This Answer Correct ?    0 Yes 1 No

Difference between datareader and dataset ?..

Answer / harsh v m

DataReader acts like Readerset of ADO.In ADO.NET we make
use of Datasets & in ADO, Readersets are used.

DataReader is read only,forward only type and Dataset is
disconnected type that can store more than one table.Hence
Datareaders are used for reading some data from database
only,but not for updating the data.Whereas Datasets can be
used for later purpose.

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More ASP.NET Interview Questions

Can we use the java script code in .Net Code behind?

5 Answers   eXensys,


6. Tell us about a time when you failed to meet a deadline. What were the repercussions?

0 Answers   AlKhaleej, Swatz Oils,


How can you apply a theme to your asp.net application?

0 Answers  


What is actually returned from server to the browser when a browser requests an .aspx file and the file is displayed?

0 Answers   MindCracker,


Can you explain what inheritance is and give an example of when you might use it?

1 Answers  






What are asynchronous callbacks?

0 Answers   Accenture,


What is page fragment caching?

0 Answers  


What is the difference between executescalar and executenonquery?

0 Answers  


Who can consume WebAPI?

0 Answers  


I have a webform in asp.net.In that webform there is 2 division class(DIV).in one of the div class there is a text box for enter the id & a button for to check id with database value.My doubt is that how can i appear the 2nd Div contents only when the id is true with database value.if wrong do not display the div . i Want code in c#.

2 Answers  


after which page life cycle event all properties of control will be "fully loaded "

10 Answers   FactorH,


how can i call output parameters from ado.net

3 Answers   TCS,


Categories