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 .net remoting?

840


What is state management react?

729


How can we register exception filter from the action?

864


List the advantages and disadvantages of user control an custom control?

747


Explain what does mvc represent in asp.net? : asp.net mvc

720


How to make sure that contents of an updatepanel update only when a partial postback takes place (and not on a full postback)?

742


Why the javascript validation not run on the asp.net button but run successfully on the html button?

764


What are the different method of navigation in asp.net?

782


Write the different features of a Thread and a Process?

896


What is data grid view in asp.net?

722


Web API supports which protocol?

1152


How do you change the session time-out value?

807


Explain server-side scripting?

813


What are the modes of updation in an updatepanel?

763


Explain how can we inherit a static variable?

796