CoolInterview.com - World's Largest Collection of Interview Questions
Send Free SMS
 Interview Questions  
 Our Services  


INTERVIEW QUESTIONS MICROSOFT ADO.NET DETAILS
Question :
What is the difference between data reader and data adapter.


Category ADO.NET Interview Questions
Rating (2.3) By 3 users
Added on 8/12/2006
Views 1572
Rate it!
Answers:

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.



the datareader read the data to database and forword mode only

and the datadapter transfer data to dabase into dataset and support dml statment



 Posted by: Ritik Prakash Mishra    

Contact Ritik Prakash Mishra  Contact Ritik Prakash Mishra


If you have the better answer, then send it to us. We will display your answer after the approval.
Name :*
Email Id :*
Answer :*
Verification Code Code Image - Please contact webmaster if you have problems seeing this image code Not readable? Load New Code
Process Verification  Enter the above shown code:*
Inform me about updated answers to this question

   
Related Questions
View Answer
How to copy the contents from one table to another table and how to delete the source table in ado.net?

View Answer
How to find the given query is optimised one or not?

View Answer
What is the execution procedure in oracle ?

View Answer
Can we connect two datareader to same data source using single connection at same time?

View Answer
Why can't we use Multiple inheritance and garbage collector paralelly in .net

View Answer
How many records can take clustured index in sql server




View Answer
Difference between SqlCommand and SqlCommandBuilder

View Answer
Why edit is not possible in repeater??

View Answer
What is the difference between data reader & data set




View Answer
How can we load multiple tables in to Dataset?

View Answer

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:

View ALL ADO.NET Interview Questions

User Options
Sponsored Links


Copyright ©2003-2010 CoolInterview.com, All Rights Reserved.
Privacy Policy | Terms and Conditions
Page URL: http://www.coolinterview.com/interview/10637/default.asp?cachecommand=bypass


Download Yahoo Messenger | Placement Papers| FREE SMS | ASP .Net Tutorial | Web Hosting | Free SMS | Dedicated Servers | Joke of the Day

0.88