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

Which method do you invoke on the DataAdapter control to load your generated dataset with data?

2 Answers  

How many no of classes in .net

4 Answers  

How many web.config files in each solution

10 Answers   General Mills,

What is the use of asp.net web api?

0 Answers  

What are the benefits of Razor View?

0 Answers   NA,




After capturing the SelectIndexChanged event for a ListBox Control, you find that the event handler doesn?t execute. What could be the problem be? a) The AutoEventWireup attribute is set to False b) The AutomaticPostBack attribute is set to False c) The codebehind module is not properly compiled d) The ListBox must be defined WithEvents.

2 Answers   Syntax Softtech,

What is a web pool?

0 Answers  

What is application Object?

0 Answers   Infogain,

How to unit test Web API?

0 Answers  

which event in global.asx that fires for every request of same user?

4 Answers   FactorH,

How to reduce the width of textbox in editcommandcolumn of datagrid?

0 Answers  

Which is faster viewbag or viewdata?

0 Answers  

For more ASP.NET Interview Questions Click Here
Categories