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

Explain the difference between response.redirect vs server.transfer

0 Answers  


what is diffrance between response.write & response.output.write

4 Answers   CTS,


What is Stateless ASP or ASP.Net?

2 Answers   Accenture,


What is cache in asp net?

0 Answers  


what is loosely coupled solution? How it can be used?

0 Answers   Siebel,


What are Http handler ?

6 Answers   Accenture, BirlaSoft, Satyam, Syntel,


What is Cookies Less Session?

0 Answers  


You are creating a Web site for Your company. You receive product lists in the form of XML documents. You are creating a procedure to extract information from these XML documents according to criteria that your users will select. When a user makes a request, you want the results of these requests to be returned as quickly as possible. What should you do? A . Create an XmlDataDocument object and load it with the XML dat Use the DataSet property of the object to create a DataSet object. Use a SQL SELECT statement to extract the requested dat B . Create an XmlDataDocument object and load it with the XML data. Use the SelectNodes method of the object to extract the requested data. C . Create an XPathDocument object and load it with the XML data. Call the CreateNavigator method to create an XPathNavigator object. Call the Select method of the XPathNavigator object to run an XPath query that extracts the requested data. D . Create an XmlReader object. Use the Read method of the object to stream through the XML data and to apply an XPath expression to extract the requested data.

1 Answers   Syntax Softtech,


What are the steps involved to fill a dataset?

0 Answers  


Why asp.net is better than php?

0 Answers  


Differentiate the session object and application object?

0 Answers  


What is the request flow used for asp.net mvc framework? : asp.net mvc

0 Answers  


Categories