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 |
What is the executescalar method?
Explain the advantage of ADO.Net?
What is ado full form?
Define partial class?
What is ado and rdo?
What are the various methods provided by the DataSet object to generate XML?
What are the different ado.net namespaces are available in .net?
What are the usages of the command object in ado.net?
what is a dataset?
What is microsoft ole db provider for sql server?
What is the current version of entity framework?
Explain the ADO . Net Architecture ?