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

Explain how can we load multiple tables in to dataset?

501


What is the difference between oledb sql server and oledbdotnet provider?

508


How can I retrieve two tables of data at a time by using data reader?

515


How is entity framework different from ado.net?

488


What are the drawbacks of using ado.net?

547






Does sqlclient and oledb class share the same functionality?

536


What are the essential features of ado.net?

541


What is ado.net object model?

514


How to bind the controls(best practice) comboboxes to the data in the dataset?

540


Describe the command object and its method.

526


How to creating a SqlCommand Object?

594


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

541


How we can provide data to ado.net?

549


What is different between sqlcommand object and command behavior object?

544


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?)

585