Difference between datareader and dataset ?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a swagger in web api?

528


What are the main advantages of using asp.net?

548


What are the components of ado.net?

526


What is csrf attack in asp.net?

514


Who can consume WebAPI?

583






Explain the concept of View Model in MVC?

587


Error : The operation couldn’t be performed because ole db provider sqlncli10 for linked server was unable to begin a distributed transaction.00000110 oledb provider for linked server returned message the partner transaction manager has disabled its support for remote/network transactions. I can able to execute the stored procedure in sql server but when i run the web page getting error like above. I did all the configuration. what is the solution?

1895


How you can return View from ASP.NET Web API method?

539


14. What are your Future Plans for Swatz Oils GROUP U.K?

1714


What is meant by server side scripting?

517


When we use cookie less session? Explain its working?

557


Is asp.net still used?

488


I have an external link in my application say www.xyztest.com. Today this site works on http protocal. Tommorow it may run on https. So i cant hardcore the protocal in the site. When a user clicks on the link how can i know if the external site works on http or https and takes him to that place?

1455


What is the use of data set in asp.net?

479


Which method is used to force all the validation controls to run?

541