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

Why is the standalone environment only useful during the development process?

0 Answers  


Write a code for passing ArrayList in Web API?

0 Answers  


How do you manage session in ASP and ASP.NET?

1 Answers   Microsoft,


hi i have a problem regarding to datagrid in aspdotnet.i have a datagrid in my application.i have to place add,edit,delete buttons or links what ever it may be. now the problem is if i click on add button then the page has to redirected to another form called "xyz.aspx" and if i click on edit button the page has to redirected to another form called "abc.aspx".i am phasing the problem that if where ever i click on the datagrid the cursor goes to gv1_SelectedIndexChanged event.please tell me the solution about the code.

4 Answers   Lambent,


Is asp.net different from asp? If yes, explain how?

0 Answers  


What is the main function of url routing system in asp.net mvc? : asp.net mvc

0 Answers  


Explain the life cycle of an ASP .NET page

2 Answers   HCL, Surya Software,


In Code-Behind class which kind of code (server or client) is found ?

0 Answers   Siebel,


What is simple data binding?

0 Answers  


In a webservice, need to display 10 rows from a table. Which is the best choice among datareader or dataset?

0 Answers  


Difference between server.Execute and response.redirect ?

5 Answers   Accenture, Keane India Ltd,


Which is faster union or union all?

0 Answers  


Categories