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


Difference between Dataset and DataReader ?

Answers were Sorted based on User's Feedback



Difference between Dataset and DataReader ?..

Answer / umamahadevan

DataSet

Data set can be said as a temporary data base which works
on disconnected architecture which stores schema and data
in application memory area..It fetches all data at a time..
DML is entertained here

DataReader

Datareader is like a forward only recordset. It fetches one
row at a time.DataReader is readonly so we cannot do any
transaction on them. DataReader will be the best choice
where we need to show the data to the user which requires
no transaction ie reports. Due to DataReader is forward
only we cannot fetch the data randomly. .NET Dataproviders
optimizes the datareaders to handle the huge amount of data.

Is This Answer Correct ?    20 Yes 3 No

Difference between Dataset and DataReader ?..

Answer / satish

The DataSet consists of a collection of DataTable objects
that you can relate to each other with DataRelation
objects. A DataSet can read and write data and schema as
XML documents..The DataReader object is the ADO.NET
counterpart of the read-only, forward-only default ADO
cursor

Is This Answer Correct ?    17 Yes 3 No

Difference between Dataset and DataReader ?..

Answer / payal

1)Data set is work in diconnected architure.
Datareader is work in connected architure.

2)according to speed datareader is faster than dataset.

3)In case of dataset it contain all
tables,relations,constriants which is not in datareader so
that speed of datareader is fast.

4)Data set can persist records where datareader is not.

5)we can save ,update data in dataset and save using
acceptchanges method where datareader cannot.

6)datareader is forward only.where dataset is not.

Is This Answer Correct ?    18 Yes 8 No

Difference between Dataset and DataReader ?..

Answer / kamlesh sharma

The DataSet consists of DataTable objects
that you can relate to each other with DataRelation
objects (and dataset is disconnected data model)

The datareader is connected model(connection must be open
while operation performs)
and it is state forward read only counter part of ADO.net

Is This Answer Correct ?    8 Yes 3 No

Post New Answer

More ASP.NET Interview Questions

What are the different types of proxy patterns?

0 Answers  


How does the browser enable AutoPostBack functionality?

2 Answers  


How many webforms are possible on a single webpage?

6 Answers  


What is the use of service provider?

0 Answers  


Difference between mvc2 and mvc3 in asp.net?

4 Answers   Wipro,


Differentiate the session object and application object?

0 Answers  


when we write the html code with runat = server it works like a server control than why we use the server control?

1 Answers  


Will the asp.net validators run in server side or client side? How do you do client-side validation in .net?

0 Answers  


Input:http://www.allinterview.com/forms/questionform.php Output:http://www.allinterview.com/forms/questionform Write c# program to get the above desired output for the given Input.....

3 Answers   Bally Technologies,


What are the different properties of server control that exists?

0 Answers   Cap Gemini,


I have a textbox , assign required field validator and i have two buttons 1) save 2) cancel , i want the validator run only when i click save button, don't validate cancel button , what to do?

7 Answers   eMids, Infotech, Integra, TCS, Wipro,


If i have a web page, and one web user control, where in web page contains a text box, and web user control have check box, if i place a web user control in the webpage, when i check the check box, the out put should show it is checked or not. How we can do this?

1 Answers   CGI,


Categories