Home  
 
  Ask Questions  
 
  Feed Back  
 
  My Questions  
 
  Contact Us  
 
  About Us  
 


 Interview Questions  
 Our Services  
NEW INTERVIEW QUESTIONS.COM MICROSOFT INTERVIEW QUESTIONS ADO.NET INTERVIEW QUESTIONS DETAILS


NewInterviewQuestions.com - Home for World's Largest Interview Questions Website.

A D V E R T I S E M E N T




Add to My Questions Add to My Questions | Forward Forward | Print Print


Question Question What is the difference between data reader and data adapter.

Answer 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

Data reader is to read the data .It can read only one row data at a time. Data adapter acts as a bridge between Database and data set.It is used to maintain the connection and it reads whole data at a time.

Answered By: Deepthi.B    Date: 12/29/2008

© NewInterviewQuestions.com


If you have the better answer, than send it to us. We will display your answer after the approval.
Answer Answer:*
Name Name:*
Email Address Email Address:*
     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:*
 


Rate the above answer. Help us to know about the answer.
Category Category ADO.NET Interview Questions
Rating Rating (3.4) By 31 users
Added Added 8/12/2006
Views Views 153742
Rate it Rate it!
Free Offers 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:





 Sponsors  

Latest 10 Answers
When there is any situation that u should attach a new patch to ur kernel , then download the patch and install it,to make changes to kernel , go to ok prompt and type boot -r, it will update or reconfigure the kernel
Honesty, helpful and reliable
procedure is a set of sql statement ,are combined to gether to perform a specific task or to solve a specifi problem.it does not return value.
leadership is power to influence a group so that the members willingly exert efforts as aspired by the leader.
I have the unique combination of technical skill and the ability to build strong customer relationship. I have the ability to stay focussed in stressfull situation. I would be great addition to your team.
first execute the bc search spec to fetch the data then executes the applet search spec if applet search spec is not match with bc it skips
TCP-Transmission Control Protocol. TCP is Reliable. TCP is Connection oriented. UDP-User Datagram Protoco UDP is Unreliable. UDP is Connectionless.
By default in structure all data member and member function are public,i,e if you not mentation any access specifier. But in case of class By default all data member and member function are private.
Structure is a user defined data type. By default all structure variables are public type and we cann't use access specifier in structure type variable, where as in class we can define objects(variables) under required access specifier type.
variable cost is the cost which is not fixed in nature

Newinterviewquestions.com is a part of Vyom Network. Top



Copyright © 2017, newinterviewquestions.com. All rights reserved Privacy Policy | Terms and Conditions

Page URL: http://www.newinterviewquestions.com/interview/10638/Default.asp?cachecommand=bypass


Download Yahoo Messenger | Web Hosting | Dedicated Server | Free SMS Domain Registration | Windows Hosting | Linux Hosting | Java Hosting | Virtual Dedicated Server | Dedicated Server | Reseller Web Hosting | Unlimited Windows reseller hosting | Unlimited Linux reseller hosting | Cheap Windows reseller hosting | Cheap Linux reseller hosting | Cheap Windows hosting | Best Windows hosting | Windows hosting Multiple Domains | Unlimited Windows hosting | Compare hosting plans | Cheap Linux hosting | Best Linux hosting | Linux hosting Multiple Domains | Unlimited Linux hosting | Cheap asp.net hosting | Best asp.net hosting | unlimited asp.net hosting | Cheap asp.net reseller hosting | Unlimited asp.net reseller hosting | Java Features | Cheap Java hosting | Best Java hosting | unlimited Java Hosting | Unlimited Linux reseller hosting | Java Hosting Multiple Domains Quick2host Reviews Buy Online Traffic