ALLInterview.com :: Home Page            
 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                      
Google
   
 
Categories >> Software >> Microsoft Related >> ADO.NET
 
 


 

 
 Visual Basic interview questions  Visual Basic Interview Questions (615)
 C Sharp interview questions  C Sharp Interview Questions (722)
 ASP.NET interview questions  ASP.NET Interview Questions (1444)
 VB.NET interview questions  VB.NET Interview Questions (151)
 COM+ interview questions  COM+ Interview Questions (41)
 ADO.NET interview questions  ADO.NET Interview Questions (199)
 IIS interview questions  IIS Interview Questions (86)
 MTS interview questions  MTS Interview Questions (5)
 Crystal Reports interview questions  Crystal Reports Interview Questions (62)
 BizTalk interview questions  BizTalk Interview Questions (33)
 Dot Net interview questions  Dot Net Interview Questions (861)
 Exchange Server interview questions  Exchange Server Interview Questions (103)
 SharePoint interview questions  SharePoint Interview Questions (25)
 WCF interview questions  WCF Interview Questions (8)
 Microsoft Related AllOther interview questions  Microsoft Related AllOther Interview Questions (193)
Question
explain connection less and with connection?diference 
between data reader,data set,data adapter? can we use data 
reader,data set in a single application? if yes explain 
with simple code,if no explain?
 Question Submitted By :: ADO.NET
I also faced this Question!!     Answer Posted By  
 
Answer
# 1
in connection less architecture connection to the database
need not be persist till the end of the process.after
fetching the data form database it is pushed in database
object called dataset and connection object need not to be
persist and its closed. and the data will be available from
the dataset.


data reader - ADO.NET DataReader to retrieve a read-only,
forward-only stream of data from a database. Using the
DataReader can increase application performance and reduce
system overhead because only one row at a time is ever in
memory.Connection to the database is maintained till the
end.it is simply like an ado object.it contains only one
table at a time.it is much faster than dataset.


dataset - is used to hold the data from the database along
with their relation. it is connection less object.it also
persist the value which are retrieved form the database.
it is a bit bulky object.it gives both forward and backward
access to data. it uses XML.it can consist more than one
table.we have atrribtes for the dataset


dataset
datatable
datarow
datacolumn

an adapter object is used to fill the data from the database.

dataadapter - dataadapter is a database object which
used to fill the dataset object with data from the database.
 
Is This Answer Correct ?    33 Yes 2 No
Kavitha
 
Answer
# 2
above exp. is excellent for connection less and connection
oriented.
data adapter performs almost five steps
1- open(create)connection
2- fatch the data
3- generate xml file of data
4- fill xml data file into the dataset by fill()method
5- closed the connection.
 
Is This Answer Correct ?    18 Yes 0 No
Prabhat Saxena(lmp)
 
 
 

 
 
 
Other ADO.NET Interview Questions
 
  Question Asked @ Answers
 
When multiple users attempt to modify data at the same time Ex user 1 is updating record at same time user2 deleted record sucessfully.now user1 has press update button . how to handle concurrency Digital-Group 4
If i am expecting a single result from sqlserverdatabase then what command should i follow ?sqlcommand.executereader (commandbehaviour.singleresult)or sqlcommand.executescalar()   4
What providers does ado.net uses internally ? Digital-GlobalSoft 3
What's the difference between Dataset.clone and Dataset.copy? Ksb 10
How to Handle the exceptions in Sqlsrver2000 SQL-Star 3
How to call the SQL commands asynchronously in ADO.NET version 2.0 DELL 4
Can we bind one datareader wid two dropdown list?   5
can u tell me the how to get the print for the form Crea 2
Why DataReader is Forward Only? NIIT 16
How To Update A Column In A DataGrid Using C#.NET? I am getting InvalidCastException as (Specified cast is not valid) while updating 2nd column in a datagrid? Id,firstname,lastname are the three columns of my datagrid respectively. I wanted to edit the second column(lastname) and update it. I did the following code in DataGrid's updatecommand(),but failed to update ! Int varid=(int)DataGrid1.DataKeys[e.Item.ItemIndex]; TextBox lnm=(TextBox)e.Item.Cells[2].Controls[0]; string str=lnm.Text ; SqlCommand cmd=new SqlCommand("update customer set lastname='" + str + "' where id=" + varid + "",con); cmd.ExecuteNonQuery(); DataGrid1.EditItemIndex=- 1; DataGrid1.DataBind(); Mind-Tree 2
What does connection string consists of ? Digital-GlobalSoft 3
We all know that Dataset is purely disconnected architechure, but we also know that we can update the changes made to the dataset can be updated in the backend database. when there is no connection how does the update happedn? Accenture 6
 
For more ADO.NET Interview Questions Click Here 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Articles  |  Site Map  |  RSS Site Map  |  Contact Us
   
Copyright 2013  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  KalAajKal.com