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                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
Google
 
Categories  >>  Software  >>  Microsoft Related  >>  ASP.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
Difference between datareader and dataset ?
 Question Submitted By :: Geethu
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Difference between datareader and dataset ?
Answer
# 1
Datareader is used for readonly-forward only data.We can't 
update the database by datareader.We  can store more than 
one resultset in the datareader so we can't create the 
relations between the tables.There is no record pointer to 
read the data in the datareader.We can read the datat from  
the datareader by using reader method.

Dataset can contain more than one table and we can create 
relationships among those tables.we can read the data by 
for each loop.Dataset can contain data from different 
datasources like oracle,sqlserver,access etc.
 
Is This Answer Correct ?    2 Yes 0 No
J_baghla
[CT]
 
  Re: Difference between datareader and dataset ?
Answer
# 2
DataReader acts like Readerset of ADO.In ADO.NET we make 
use of Datasets & in ADO, Readersets are used.

DataReader is read only,forward only type and Dataset is 
disconnected type that can store more than one table.Hence 
Datareaders are used for reading some data from database 
only,but not for updating the data.Whereas Datasets can be 
used for later purpose.
 
Is This Answer Correct ?    1 Yes 0 No
Harsh V M
 
 
 

 
 
 
Other ASP.NET Interview Questions
 
  Question Asked @ Answers
 
Difference between ADO.Net 1.1 and ADO.Net 2.0 ? Value-Labs1
difference between Trace and Debug ? Accenture2
how to use web services with code?(with example code) Accenture1
what is asp dotnet  1
About session modes Wipro2
How do you perform validations? Microsoft2
when user is logged on the information is saved in a cookie, what is the name of that cookie? Mind-Tree2
WHT IS DIFFERENCES BETWEEN HTML CONTROLS AND SERVER CONTROLS. HCL9
Differences between session state and Application state?  2
What does this do? sn -t foo.dll  2
how can you bind data from dataset to XML file LG-Soft2
please give a brief knowledge about these events ? page_render() page_prerender() page_unload page_loadcomplete page_preinit Netsweeper1
If I'm developing an application that must accommodate multiple security levels though secure login and my ASP.NET web application is spanned across three web-servers (using round-robin load balancing) what would be the best approach to maintain login-in state for the users? Syntax-Softtech7
What methods are fired during the page load?  1
How we can kill our Session in web farm where there is no any sticky server .And user can not Logout bcoz of that.  1
What is the difference between control and component?  2
What is meant by role based security? when we use this one  1
You are using the try? catch block seen in the following code segment, but no exceptions are ever caught by the catch block. What is the problem? SqlConnection cn =new sqlConnection(strSQL); SqlDataSet ds; try { cn.open(); //perform the data processing steps ??.. } catch (OleDbException e) { ?.. } a) The exception class is wrong; it should be sqlErrors. b) The exception class is wrong; it should be sqlSyntaxExceptios. c) The exception class is wrong; it should be sqlExceptions. d) The exception class is wrong; it should be sqlExcptions. Syntax-Softtech2
What is CTE in sql server 2005? Minecode2
About remoting and web services. Difference between them? Microsoft2
 
For more ASP.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