Diff b/w DataReader,Dataset and Data table?
Answers were Sorted based on User's Feedback
Answer / nityanand
Dataset:Disconnected Architecure and Relation between Row
and Column
Datareader :Connected architecture and Forward only and
read only data access.
DataTable : It is collection of data Rows and Column.
Is This Answer Correct ? | 59 Yes | 2 No |
Answer / 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 |
Answer / venu
DataReader: datareader is forward only it is nt scrollable
and datareader fetch the records one by one.this is record
pointer to pointing to one by one record in connected
Architecture.
Dataset:dataset is contain table in Xml format.we can use
this forward to any operating system.it is Scrollable and
dataset contain in application memory.
Datatable: DataTable Contain a structured format it contain
a rows and columns.
Is This Answer Correct ? | 4 Yes | 3 No |
Answer / sooraj
dataset :-
dataset used disconnected mode(offline architecture) dataset
contain object of data table by using dataadapter by fill
method means dataadapter fill the fetch query of datatable
to data set..
datareader:-
its use connected mode arcetecture..its secure but
connection oriented.. its working some time we can say that
its same as a dataset but its direct access data by table..
datatable :- structured format it contain
a rows and columns.
Is This Answer Correct ? | 3 Yes | 2 No |
Answer / 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 |
How do you merge 2 datasets into the third dataset in a simple manner?
Which control of the BindingNavigator returns the current position within the data source?
Explain how to pass multiple tables in datasets simultaneously?
What is the functionality of data provider in ado.net?
What is difference between connected and disconnected architecture in ado.net?
Which namespaces are used for data access?
0 Answers SwanSoft Technologies,
can u tell me the why ADO does not support xml..
Difference between function and trigger?
How can you identify whether or not any changes are made to the DataSet object since it was last loaded?
Which database is the ado.net?
What is dbcontext and dbset in entity framework?
What do you know about ADO.NET's objects and methods?