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 a control toolbox?
What are the advantages using ado.net?
How do you update database through dataset?
What is difference between Dataview and Datatable?
What is a dataview?
What are the steps in connecting to database?
how would i implement dropdownlist in gridview using c#
How do you filter the data in datagrid?
2 Answers Apps Lab, Choice Solutions,
Explain the overview of ado.net architecture?
What are disadvantages of microsoft-provided data provider classes in ado.net?
Which one of the following objects is a high-level abstraction of the connection and command objects in ado.net?
How to load multiple tables into a dataset?