Diff b/w DataReader,Dataset and Data table?

Answer Posted / deepak

DataReader:- is a predefined class that access the data
forward only and read only mode,and it belongs to connected
architechure.
Dataset:- is a buffer location between database and
application.All the manipulation are done here rather than
directly database.it belongs to disconnected architechure.

DataTable:- is the collection of rows and columns in the
dataset.In other sentence,The table in the dataset is called
DataTable.

Is This Answer Correct ?    19 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

571


What is microsoft ole db provider for sql server?

480


How can I retrieve two tables of data at a time by using data reader? Data reader read and forward only, how is it possible to get 2 tables of data at a time?

525


What is the difference between typed and untyped dataset?

510


Explain how to pass multiple tables in datasets simultaneously?

497






What is openrowset?

501


What is ado.net in mvc?

501


Which namespaces are used for data access?

628


Which components of a data provider is used to retrieve, insert, delete, or modify data in a data source?

622


What are the different layers of ado.net?

520


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?

562


How to add a javaScript function in a datagrid?

571


Which object is used to add relationship between two Datatables?

579


What are the different methods by which we can populate a dataset?

693


What is row state?

529