ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
Google
 
Categories  >>  Software  >>  Microsoft Related  >>  ADO.NET
 
 


 

 
 Visual Basic interview questions  Visual Basic Interview Questions
 C Sharp interview questions  C Sharp Interview Questions
 ASP.NET interview questions  ASP.NET Interview Questions
 VB.NET interview questions  VB.NET Interview Questions
 COM+ interview questions  COM+ Interview Questions
 ADO.NET interview questions  ADO.NET Interview Questions
 IIS interview questions  IIS Interview Questions
 MTS interview questions  MTS Interview Questions
 Crystal Reports interview questions  Crystal Reports Interview Questions
 BizTalk interview questions  BizTalk Interview Questions
 Dot Net interview questions  Dot Net Interview Questions
 Exchange Server interview questions  Exchange Server Interview Questions
 SharePoint interview questions  SharePoint Interview Questions
 Microsoft Related AllOther interview questions  Microsoft Related AllOther Interview Questions
Question
Why DataReader is Forward Only?
 Question Submitted By :: Amit Sharma
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Why DataReader is Forward Only?
Answer
# 1
Because it suppport the disconnected architecture :)
 
Is This Answer Correct ?    18 Yes 53 No
Ankit
 
  Re: Why DataReader is Forward Only?
Answer
# 2
Data Reader worked as conventional Record Set of VB
and
Data Reader worked in connected mode only
 
Is This Answer Correct ?    29 Yes 5 No
Lovely
 
 
 
  Re: Why DataReader is Forward Only?
Answer
# 3
Because it supported dissconnected architecture
 
Is This Answer Correct ?    3 Yes 42 No
Deepak Rai
 
  Re: Why DataReader is Forward Only?
Answer
# 4
because it satisfy read only property from which we can only
retrieve data only(forword) not write to int(backword).
 
Is This Answer Correct ?    13 Yes 5 No
Guneetinder Singh
 
  Re: Why DataReader is Forward Only?
Answer
# 5
DataReaader 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.
 
Is This Answer Correct ?    27 Yes 1 No
Vrushali
 
  Re: Why DataReader is Forward Only?
Answer
# 6
datareader execute data from table one by one at each
calling of it.and to fetch next value from database it
contains pointer value(index) of next value . thats why if
is forward only. in the oops concept it works on the concept
of one-way linklist
 
Is This Answer Correct ?    14 Yes 1 No
Rahul Singhal
 
  Re: Why DataReader is Forward Only?
Answer
# 7
A DataReader is a stream of data that is returned from a 
database query. When the query is executed, the first row 
is returned to the DataReader via the stream. The stream 
then remains connected to the database, poised to retrieve 
the next record. The DataReader reads one row at a time 
from the database and can only move forward, one record at 
a time. As the DataReader reads the rows from the database, 
the values of the columns in each row can be read and 
evaluated, but they cannot be edited.
 
Is This Answer Correct ?    11 Yes 0 No
Manumole
 
  Re: Why DataReader is Forward Only?
Answer
# 8
As we know that DataReader is connected architecture it 
cannot persists the contents. it reads the contents one by 
one record from the dataset until all the records completed.

 The main thing is data reader uses pointers to fetch the 
next record(index).hence these are the forward only objects
 
Is This Answer Correct ?    2 Yes 0 No
Sandyni
 
  Re: Why DataReader is Forward Only?
Answer
# 9
Because it supports connected architecture.
 
Is This Answer Correct ?    0 Yes 0 No
Pawan
 

 
 
 
Other ADO.NET Interview Questions
 
  Question Asked @ Answers
 
can we have multiple datatables in a datareader ? Ness-Technologies14
When we are running the Application, if any errors occur in the Stored Procedure then how will the server identify the errors? HCL4
what is the criteria of selection in sbi interview? SBI1
What are advantages and disadvantages of Microsoft-provided data provider classes in ADO.NET?  2
What providers does ado.net uses internally ? Digital-GlobalSoft2
What is method to get XML and schema from Dataset?  2
how do u connect ado.net to sql server Microsystems1
what is sql Injection? Microsoft4
what is different between SqlCommand object and Command Behaviour Object  3
Write steps of retrieving data using ado.net ? Keane-India-Ltd2
How would u connect to database using .NET? TCS3
what purpose of Indexing creating? directly we can search the reqired row with the help of query?what is the use of indexing?  3
Diff B/W DataSet vs DataTable Star-Wire4
How do you handle data concurrency in .NET ?  7
Difference between ADO and ADO.net ? Accenture7
i have two textboxes one for user name and another for password . i have a table name compare(which contains name,passwod etc.,)my doubt is how compare username textbox with name column and how compare password textbox with passwod column. i want the code Wipro5
Sequence to connect and retrieve data from database useig dataset ? MMTS3
What is sequence of code in retrieving data from database ? Accenture2
What are the two fundamental objects in ADO.NET? Ksb3
Features and disadvantages of dataset? Microsoft2
 
For more ADO.NET Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com