Difference between datareader and dataset?

Answer Posted / ganesh

datareader(connection oriented) is a read only and forward
only record set which will have the data retrieved based on
the select statement.we can't do DML operations through
datareader.

whereas dataset(disconnected) model which we can do all the
DML operations.

Is This Answer Correct ?    111 Yes 20 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the default Timeout for SqlCommand.CommandTimeout property?

713


What is data relation in ado.net?

691


how to create a quiz software using 4 options to answer and how to check with answers in the database and award marks....

3956


What is ado.net in mvc?

658


Is datareader faster than datatable?

696






What is the DataTableCollection?

772


What are the advantages of using datalist?

676


How can we add relation between tables in a dataset?

723


What is difference between ado.net and asp net?

722


What is ole db and odbc?

679


Define isolation?

723


How do I delete a row from a DataTable?

750


How to add a javaScript function in a datagrid?

767


What is the difference in an abstract class and an interface?

696


What are the ado.net connection pooling parameters?

636