Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Microsoft Related >> ADO.NET
  2. Suggest New Category

Diff b/w DataReader,Dataset and Data table?

Question Posted / manis_venu

Answers were Sorted based on User's Feedback



Diff b/w DataReader,Dataset and Data table?..

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

Diff b/w DataReader,Dataset and Data table?..

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

Diff b/w DataReader,Dataset and Data table?..

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

Diff b/w DataReader,Dataset and Data table?..

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

Diff b/w DataReader,Dataset and Data table?..

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

Post New Answer

More ADO.NET Interview Questions

What is the significance of CommandBehavior.CloseConnection ?

0 Answers   NA,

What is @@rowcount and with small code snippet explain the usage?

4 Answers   BirlaSoft,

What are the methods of XML dataset object?

0 Answers  

Differnce between Stored procedure and user defined functions?

17 Answers   Microsoft, Symphony,

make a login control??

1 Answers  

Explain the difference between ado and ado.net?

0 Answers  

What is an orm, and why would you use one instead of plain old ado.net?

0 Answers  

What is ambient transaction?

0 Answers  

What is partial class?

0 Answers  

What does executequery return?

0 Answers  

once data is fetched into dataset connection gets closed. but in datareader connection is always maintained...then why datareader is fast and mainly recommended ?

2 Answers  

What is ado.net objects?

0 Answers  

For more ADO.NET Interview Questions Click Here
Categories