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

Question Posted / rajatsachdeva.virgo

3 Answers
10361 Views
HCL, NIIT, I also Faced
E-Mail Answers

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

What is the exact purpose of http handlers?

0 Answers

You are planning the deployment of an ASP.NET application. The application uses a Visual Studio .NET component named DataAccess that will be shared with other applications on your Web server. You are using Visual Studio .NET to create a Windows Installer package. You need to deploy DataAccess and the ASP.NET application so that they can be uninstalled later of necessary. What should you do? A . Create a setup project for DataAccess. Add the ASP.NET application in a custom action. B . Create a setup project for the ASP.NET application. Create another setup project for DataAccess. C . Create a Web setup project for the ASP.NET application. Add a project output for DataAccess. D . Create a Web setup project for the ASP.NET application. Add a merge module for DataAccess.

3 Answers Syntax Softtech,

What is the used of "ispostback" property?

0 Answers

What is ispostback method in asp.net? Why do we use that?

0 Answers

How can we create a website?

0 Answers

Do you know caching feature?

0 Answers

Explain automatic memory management in .net.

0 Answers

What is webresource axd?