Diff. b/w DataReader and DataSet?

Answer Posted / tejas mer

DataReader is connected architecture and it's read-only, forward only type, so when you just want to display the data better to use it, it consumes less memory with compare to dataset as well.

DataSet is we can say in-memory representation of the data.
It's disconnected architecture.
Contains DataTables, which are further divided into Datarows and Datacolumns.
Also contains DataRelationships and Contraints...

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does executereader return?

749


Explian About DataAdapters

810


What does ado stand for in ado.net?

733


What is oledb driver?

722


What is a datareader object?

851


What Is Difference Between Ado And Ado.net?

790


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

4030


How is it possible to get 2 tables of data at a time by using data reader?

716


Which method is used to sort the data in ADO.Net?

1770


What are all features of ADO.Net?

760


How to read data with the sqldatareader ?

771


Explain the advantage of ADO.Net?

772


Give few examples of datareader that is used in different dataproviders.

764


What is ole data type?

718


What is the significance of CommandBehavior.CloseConnection ?

879