Sign Up Login


  1. Categories >> Software >> Microsoft Related >> ASP.NET
  2. Suggest New Category

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

Question Posted / rajatsachdeva.virgo

Answers were Sorted based on User's Feedback



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

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

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

Answer / lavanya

With Dataset can retrive the data from two database like
oracle, SQl and merge in one table. Record set is not
possible.

All representation of dataset is using XML while record set
use COM.

Recordset can not be transmitted on HTTP while Dataset can
be.

Is This Answer Correct ?    6 Yes 1 No

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

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

More ASP.NET Interview Questions

i have 3+ exp in .net? i am going interview now but they asked me do you know any TOOL? which tool will i study please refer me?

0 Answers   Wipro,

In which interface the template of any control like Gridview would Initiate?

2 Answers  

Differences between VB.Net and C#, related to OOPS concepts

5 Answers   CSC,

What are the Difference between asp.net and asp ?

0 Answers  

What is the difference between adding reference in solution explorer and adding references by using ?

0 Answers  




Will session work if cookies is disabled?

0 Answers  

Disable Mouse right click on web page in asp.net?

0 Answers   HCL,

What are the Application_Start and Session_Start subroutines used for?

5 Answers   Siebel Systems,

Why we use dbms for projects? Why don’t we save any application data in separate files instead of dbms?

0 Answers  

What is the difference between web config and machine config files?

0 Answers  

Explain automatic memory management in .net.

0 Answers  

What is CTE in sql server 2005?

3 Answers   Minecode,

For more ASP.NET Interview Questions Click Here
Categories