What is the difference between a Dataset and DataReader?
Can dataReader hold data from multiple tables?

Answer Posted / sandyni

DataSet is a disconnected object and holds the data from
datastore. It can hold the data of more than one table.

where as dataReader is connected architecture which can
rbe used to read the data from the dataset in forward only
fashion. DataReader cannot hold multiple tables of data.

Is This Answer Correct ?    1 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is ole data type?

691


What is ado and dao?

711


What is the difference between linq and ado.net?

714


what is the difference betwen typed dataset and untyped dataset?in general which dataset can we use in programming?

736


What is ado in agriculture?

684


What does executereader return?

712


What is dbcontext and dbset in entity framework?

673


What are the key events of sqlconnection class?

833


Explain what are the steps to connect to a database?

714


What is data control techniques?

686


Which is the feature of ado.net?

725


how we can fire event in databound coulm in datagfrid withot using button?

736


What is the difference between DataReader and DataSet in ADO.NET?

789


What is data access pattern?

663


What is the difference between Response.Expires and Reponse.ExpiresAbsolute?

774