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

Explain About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.

551


What is disconnected architecture in ado.net?

498


What does ado stand for in ado.net?

450


What is the advantage of ado.net?

538


What is difference between datagridview and datagrid control in winforms?

510






What is ado asp?

511


What are the features of ado.net?

495


Is ado.net an orm?

510


Explain how to find the given query is optimised one or not?

509


Which object is used to add relationship between two Datatables?

572


What are the uses of Stored Procedure?

549


How we can provide data to ado.net?

543


What are the disadvantages of using datalist?

501


How to connect and retrieve data from database using dataset

530


What are the connected and disconnected modes in ado.net?

475