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

What is the concepts of globalization and localization in .net?

717


What is the difference between session.abandon() vs clear()?

722


What are the security types in ASP/ASP.NET? Different Authentication modes?

763


Do gac'ed assemblies have fulltrust?

846


What are the media types of http requests and response?

712


What is the difference between client-side and server-side validations in ASP.NET?

871


What is state management techniques in asp.net?

738


Why do we need Sessions?

753


To display data in a Repeater control which template you provide?

776


How do cookies work? Give an example of their abuse.

732


Can we add code files of different languages in app_code folder?

818


Explain the difference between AutoPostBack and IspostBack in ASP.NET?

799


Define session in asp.net.

712


How tooltip is set through code-behind in ASP.NET?

811


Why the javascript validation not run on the asp.net button but run successfully on the html button?

729