NEW INTERVIEW QUESTIONS.COM MICROSOFT INTERVIEW QUESTIONS ADO.NET INTERVIEW QUESTIONS DETAILS

Add to My Questions | Forward | Print

Question

What is the difference between data reader and data adapter.

Answer

DateReader is an forward only and read only cursor type if you are accessing data through DataRead it shows the data on the web form/control but you can not perform the paging feature on that record(because it's forward only type). Reader is best fit to show the Data (where no need to work on data) DataAdapter is not only connect with the Databse(through Command object) it provide four types of command (InsertCommand, UpdateCommand, DeleteCommand, SelectCommand), It supports to the disconnected Architecture of .NET show we can populate the records to the DataSet. where as Dataadapter is best fit to work on data. datareader works only in readonly and forward only mode whereas in dataadapter u can store the data in the dataset and perform all the operations like insertion,deletion,updation,selection Answered By: aastha mehra    Date: 7/10/2007 Datareader is forward only read only recordset.DataAdapter is used to connect the Dataset to Daabase.it's just like a bridge between dataset and he database. Answered By: putti    Date: 7/14/2007 DATAREADER: IT IS JUST "READ ONLY FORWARD ONLY". DATAADAPTER: IT IS USED TO CONNECT TO THE DATABASE.IT IS LIKE A BRIDGE B/W DATASET & DATABASE. Answered By: SURESH    Date: 11/12/2007 no difference Answered By: sathi.    Date: 12/28/2007 DATA READER IS ONLY READ THE DATA FROM DATABASE(CONNECTED ARCHITECTURE) DATA ADAPTER IS NOT ONLY READ THE DATA IT SUPPORT INSERT,DELETE,UPDATE FOR DISCONNECTED ARCHITECTURE Answered By: tAMILSELVAN S    Date: 4/4/2008 DataReader directly access the table and it is only used for reading the records from it whereas dataadapter, used to maintain connection, is always used with dataset as dataset is of disconnected-architecture in nature. Answered By: Santosh tilak    Date: 5/8/2008 Data Adapter receives the whole data at once, while Data Reader has the ability to read data line by line. means one row at a time. Answered By: SureshG_303    Date: 6/12/2008 Apart from above facts, datareader is faster then adapter in processing. Answered By: gaurav sethi    Date: 7/12/2008 Data reader is only for to read the data.it is only one direction. data adapter is communicator b\w db and data set. Answered By: sruthi    Date: 11/1/2008 © NewInterviewQuestions.com

Answer:*
Name:*
Email Address:*
Verification Code	Not readable? Load New Code
Enter the above shown code:*

Category	ADO.NET Interview Questions
Rating	(3.9) By 10 users
Added	8/12/2006
Views	153742
Rate it!	* * * * * * * * * * * * * * *
Free Offers:	300 Free Magazines for you. No credit card required. No Shipping Charges. Absolutely Free for 1 Year.

Please Note: We keep on updating better answers to this site. Subscribe to our newsletter to get notified when better answer is posted.

Notify me when better answer is posted!
Email: