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 to get the new oledb connection of oracle in database programming?
What is the use of sqldatareader class?
What is an ADO.Net?
What is ado object model?
How to add an aggregate column?
What is execute scalar in ado.net?
How to find the count of records in a dataset?
Can we create Synonymns in MS Acess,My Sql Server,Sql Server? But iam we can create in oracle!
How do you merge 2 datasets into the third dataset in a simple manner?
Define Execute Scalar?
Define Execute Reader?
What provider ado.net use by default? Explain the role of data provider in ado.net?