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 the functionality of data provider in ado.net?

483


How can we load multiple tables in to dataset?

559


What are the key events of sqlconnection class?

595


What is microsoft ado.net?

567


What is difference between ado.net and asp net?

502






What are the benefits of using of ADO.NET in .NET 4.0?

527


Explain what is datagrid with an example?

575


What is aggregating data ?

500


What is an orm, and why would you use one instead of plain old ado.net?

561


What are dataproviders?

531


How can we save all data from dataset?

531


What is dao and ado?

470


What is the usage of the dataset object in ado.net?

477


What is ado.net and its architecture?

493


What is row state?

512