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 are all the different methods under sqlcommand?

725


What is executenonquery ado.net?

736


What is execute reader in ado.net?

711


What is the difference between ado.net and oledb?

716


Explain how do you connect to sql server database without using sqlclient?

726


What is difference between ado and other data object?

692


What is ole used for?

707


What is datatable in ado.net?

737


How can you add or remove rows from the datatable object of dataset?

810


What are the ado.net connection pooling parameters?

676


What does sqldatareader return?

723


What is basic use of data view?

747


How do you update a dataset in ado.net?

782


What is two way data binding android?

744


What is difference between executequery and executeupdate?

727