Difference between datareader and dataset?

Answer Posted / sumanth

Data Reader:A class used to efficiently process a large list
of results one record at a time.

Data Set:A Data Set object represents a schema (either an
entire database or a subset of one). It can contain tables
and relationships between those tables.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define executenonquery?

527


What are the 3 major types of connection objects in ado.net?

544


What is ole db and odbc?

521


What is dataset and datatable in ado.net?

503


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

507






What is dataadapter in ado.net?

498


Describe ado.net object model in detail.

534


What are the differences between OLEDB and SQLClient Providers?

565


Is it possible to load multiple tables in a Dataset?

530


Which method is used by command class to execute SQL statements that return single value?

559


What is ado circle?

665


What property must be set and what method must be called in your code to bind the data from some data source to the Repeater control?

561


Describe the disconnected architecture of ADO.NET’s data access model.

543


Describe datareader object of ado.net with example.

511


What are the different row versions available in table?

531