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

Answer Posted / irfanpathan

Dataset is used to get the data from database by creating
objects..After getting data we should store that data.we
use SQLDATAADAPTER for storing data..after storing we will
give connection with SQLCONNECTION class.and then we bind
the data using DATABIND..This total process is appliued
with DATASET.
where as DATAREADER is also for getting data through
database.But it is faster in access.we wont use DATAREADER
because of performance problem..
i too dont know record set..

Is This Answer Correct ?    9 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Differentiate between structure and class.

761


What are the new features added from ASP to ASP.NET?

795


How can exception be handled with out the use of try catch?

750


What is asp.net? How is it different from asp?

762


Explain the difference between the web config and machine config.

816


What is the full meaning of asp.net?

711


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

789


What is difference Between Authentication and authorization?

816


Dataset is the disconnected environment. suppose if you are binding records to gridview (disconnected environment) and you are making changes to the the grid but before updating the database if any other user modify the data, how will you avoid such problem?

1933


Explain the difference between array and linkedlist?

723


What is the difference between response.redirect and server.transfer?

747


What does mvc represent in asp.net? : asp.net mvc

754


How will you maintain versioning in asp.net 2.0?

762


What is active web pages?

698


What is server infrastructure?

805