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...


What are the differences between Dataset and DataReader?

Answers were Sorted based on User's Feedback



What are the differences between Dataset and DataReader?..

Answer / kautilya

Dataset is in memory representation of the Database. where
you can create tables, relations between tables, add
primary key to tables and also manipulate the data
retrieved form the database. It allows us to work in
connection less environment.

Datareader is like forward only readonly cursor, which is
used to retrieve data. data manipulation is not possible
while using datareader. datareader continously keeps the
connection open.

Is This Answer Correct ?    13 Yes 0 No

What are the differences between Dataset and DataReader?..

Answer / saravanan

dataset is a connectionless service but data reader is a
connection oriented service..

Is This Answer Correct ?    7 Yes 0 No

What are the differences between Dataset and DataReader?..

Answer / eduardo belmonte

A ds (dataset) can be used when the connection is closed.
A dr (datareader) needs the connection open to be used.

A ds can be used to modify or delete or insert data in the
database.
A data reader can be used only to read data

A ds can let you access the info on any order at any time.
A dr lets you access the info only one time per item and
only in a sequential order.

A ds data can be loaded in longer time than a dr can be
loaded at.

A ds can contain separated and structured data from several
database tables.
A dr can contain data in one register per item, that
register can include data from serveral tables id the sql
select statement so indicates, but it has no separate
structure per table.

Is This Answer Correct ?    7 Yes 0 No

Post New Answer

More ASP.NET Interview Questions

What is a runtime version?

0 Answers  


How do you initiate validation on the server manually? What are two situations when you might you want to do that?

0 Answers  


i develop a web application and i gave security setting i.e autherization and athentication now it work properly on my local system , now question is ,is this security setting ie autherization and athentication which i gave in web.config will it be enough strong to secure my application on internet or i have to use some 3rd party tool or software to get security .if yes --how ? if no--what is the alternate?

0 Answers  


What is asp.net globalization?

0 Answers  


Is it possible to develop a single web application using ASP.NET webforms and ASP.MVC?

0 Answers  


What are Authentication and Authorization?

0 Answers  


what is synchronization and asynchronization. what are the difference between two?

1 Answers   TCS,


Differentiate an ADO.NET Dataset and an ADO Recordset with its functionality?

3 Answers   Siebel,


What are sessions and cookies?

0 Answers  


Define static member?

0 Answers  


I have got less marks in bsc it So how to get interview.tell me

1 Answers  


Difference between ISQL and OSQL??

1 Answers  


Categories