Difference between ADO.net Dataset , ADO Record Set & ADO Data Reader?

Answer Posted / lovenier

We use DataSet to retrieve data from database in disconnected mode, but in the data RecordSet it retrieve data in connected mode..
DataSet is designed to work without any continuing connection to the orignal database, but RecordSet is Required a connected environment.
Data in DataSet is bulk loaded, rather than being loaded on demand.
DataSet have no concept of Cursor and current pointer, you can use for each loops to move through data.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can you enable impersonation in the web.config file?

659


Which dll handles the request of .aspx page?

660


How does asp.net work?

638


What are ASHX files?

684


What’s difference between “optimistic” and “pessimistic” locking?

662






What is Cookies Less Session?

701


What are the versions of garbage collection?

1544


Fetch one page value to another page without using state-managment ?

612


Explain automatic memory management in .net.

671


Explain the different types of directives in .net?

596


What is caching? Explain.

638


What is inproc mode in session?

592


What is the difference between mvc and asp.net? : Asp.Net MVC

563


Describe SOA and the tenets of it?

652


How can we apply themes to an asp.net application?

640