Diff. b/w DataReader and DataSet?

Answer Posted / sandeep singh shekhawat

Data Reader is forword only it read one by one row. when it reach end the table then need to another connection open for it. it object create by command object method execute reader.

Data set is used for disconnect approch.It can have more than one table.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is typed dataset ?

668


What are all the classes that are available in System.Data Namespace?

548


What is meant by executenonquery?

522


What are the drawbacks of using ado.net?

539


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

535






Explain the role of data provider in ado.net? What is the role of data provider in ado.net?

519


What is sqlconnection and sqlcommand?

507


What is the difference between data grid and data repeater?

500


Why do we need ado.net?

534


How to find the given query is optimised one or not?

500


What is the significance of CommandBehavior.CloseConnection ?

560


What is a serialized object?

530


What are the advantages using ado.net?

529


Explian About DataAdapters

576


What provider ado.net use by default? Explain the role of data provider in ado.net?

518