Home  
 
  Ask Questions  
 
  Feed Back  
 
  My Questions  
 
  Contact Us  
 
  About Us  
 
 Interview Questions  
 Our Services  

Get 9,000 Interview Questions & Answers in an eBook.


  • 9500+ Pages
  • 9000 Question & Answers
  • All Tech. Categories
  • 14 MB Content

    Get it now !!



    Send your Resume to 6000 Companies

  • 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 & data set




    Answer Answer DataReader is connected object and one can process the rows that are returned by query, one at a time. It discards every row after you have gone through it and so it is extremely fast.It contains only read-only data, so no updates are allowed using DataReader objects.

    In DataReader you can not get the no. of records directly from RecordSet.This is similar to VB 6, ForwardOnly RecordSet.

    Meanwhile DataSet is disconnected object type.It uses XML to store data


    Data reader is much faster then dataset if only selection query is their


    1)DataReader is used in connected architecture while DataSet is used in disconnected architecture with DataAdapter. 2)As DataReader is forward only we can't edit in it,but in dataset we can. 3)DataReader is comparetively faster than DataSet.

    Answered By: Ankita Jain    Date: 4/21/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 (5.0) By 1 users
    Added Added 7/27/2006
    Views Views 154040
    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:


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





     Sponsors  
    Latest 10 Answers
    Satellite assemblies are purely based on culture,these are loaded dynamically.
    Cache is the memory that services thr CPU.It is faster than the main memory and allows the CPU to execute instructions and read and write data at a higher speed.
    Bank reconciliation is a Statement prepared by the customer to find out the differences in the cash book prepared by him and the pass book given by the bank.
    Asp. net is event driven, code is separated from the html,events are handles on server side. and asp.net uses the compiled code while asp interprets the code.
    Controls which does not have align property cannot be placed in MDI forms.
    A DSN (Data Source Name) is an identifier which defines a data source for an ODBC driver. A DSN consists of information such as: Database name Directory Database driver User ID Password
    The serialization is a process in which we can stored in data in the persistence medium like file ,hard disk etc ...in a serialize form...
    Line and Shape controls dont have a events.
    ABAP is basic (technical) side of SAP. which helps other function of business sibe ex.financial,sales,inventory& human resource.
    Cluster index work as a primary key and as we know in a single table only one primary key should be there....Hence only one records can take cluster index.

    G o o g l e Search

    Google

    Newinterviewquestions.com is a part of Vyom Network. Top



    Copyright ? 2008, newinterviewquestions.com. All rights reserved Privacy Policy

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


    Download Yahoo Messenger