Difference between Dataset and DataReader ?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain ViewState?

572


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

1354


Explain the steps to be followed to use passport authentication.

582


What are the different types of validation controls provided in ASP.NET?

661


What is the difference between user control an custom control?

610






Explain client-side scripting?

563


What are validators and list some validators of asp.net?

535


What are session and cookies?

525


What are early binding and late binding.

561


What parameters can you pass in the url of the api?

656


Can you explain one critical mapping? Performance issue which one is better?

463


What is http pipeline in asp.net?

509


What is autopostback in asp net?

581


What is rich control in asp.net?

517


What is a postback url?

489