Diff b/w DataReader,Dataset and Data table?

Answer Posted / neha

DataReader: It is used to retrieve a single record of a
table at a time. It does this in forward-only, read-only manner.

DataTable: It is used to represent a single table of the
dataset.

DataSet: It is the collection of DataTables and the
DataRelations.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between Optimistic and Pessimistic locking?

538


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

585


What is the difference between ado.net and entity framework?

496


Which is faster sqldataadapter and sqldatareader?

494


Explain the difference in an abstract class and an interface?

497






Give an example that shows how to execute a stored procedure in ado.net?

559


What is concurrency? How will you avoid concurrency when dealing with dataset? (One user deleted one row after that another user through his dataset was trying to update same row. What will happen? How will you avoid the problem?)

577


What is dataset object? Explain the various objects in dataset.

585


Which one of the following objects is a high-level abstraction of the connection and command objects in ado.net?

578


In how many ways we can retrieve table records count? How to find the count of records in a dataset?

538


What is ado.net object model?

508


What is defaultview in datatable?

531


Which method in OLEDBAdapter is used to populate dataset with records?

556


What is ado.net tutorial?

498


How can we load multiple tables in to dataset?

568