Difference between datareader and dataset?

Answer Posted / raghavendra.v

DataReader is conncetion oriented u can find the changes in
the database reflected in data reader immediately

where as dataset is pure disconnected one you will find the
changes only when u refresh the dataset using dataadapter

Is This Answer Correct ?    50 Yes 13 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is DataReader Object?

786


What is the difference between a datareader and a dataset?

712


What is datasource in ado.net?

822


What are the uses of Stored Procedure?

781


What is Dataset Object?

765


What is the difference between Data adaptor and Data set?

786


Explain the differences between oledb sql server, oledbdotnet provider?

756


Define executenonquery?

703


How can you identify whether or not any changes are made to the DataSet object since it was last loaded?

793


What is a non query?

705


What is difference between executequery and executeupdate?

707


How does ado.net work?

678


Data reader read and forward only, how is it possible to get 2 tables of data at a time?

686


What is Data view?

786


What is execute reader in ado.net?

697