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?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Is it possible to write code in many languages in one asp.net project?

1032


How to implement globalization and localization in the use interface in .net.

1015


What is inproc and outproc?

993


Explain the difference between asp & asp.net.

1024


Can viewstate be accessed in another page?

1036


How many web config files can be created for an application?

865


What is the significance of proxy user?

1087


What is the use of view state?

948


What New Features comes with ASP.NET Web API 2.0?

1024


Define resource files.

971


What is difference between view and partial view?

930


I have an external link in my application say www.xyztest.com. Today this site works on http protocal. Tommorow it may run on https. So i cant hardcore the protocal in the site. When a user clicks on the link how can i know if the external site works on http or https and takes him to that place?

1910


Explain the basic functionality of garbage collector?

985


What is autopostback in dropdownlist in asp net?

995


What are the different authentication modes in asp.net?

1020