Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

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 a 404 redirect?

0 Answers  


How can we register exception filter from the action?

0 Answers  


hi guys do u know how to go one page to one page to another page plz tell me any of u know

3 Answers  


Can we have multiple master pages in asp net?

0 Answers  


Name the method that needs to be invoked on the dataadapter control to fill the generated dataset with data?

0 Answers  


What is the difference between Hash table and Array list?

0 Answers  


How may clustered index we can create in table?

0 Answers  


When working with ASP.Net server controls, it is important to use the right event handlers to capture the event for the application to function properly. What event would you use to capture the selection of a new item in a DropDownList control? a) The Click event. b) The SelectionChanged event. c) The SelectionIndexChanged event. d) The ChangedSelection event.

4 Answers   Syntax Softtech,


Which type of state management is provided by Query String in ASP.NET?

0 Answers   Sans Pareil IT Services,


Describe a Windows Service and its lifecycle ?

0 Answers   Siebel,


Give 2 examples for scenarios when routing is not applied?

0 Answers   NA,


What is the difference between localization and globalization?

0 Answers  


Categories