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   SiteMap shows list of All Categories in this site.
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
Execute nonquery returns no. of afected rows.So if my stored 
procedure hav lot of select stmnt, delete stmnt, insert 
stmnt..then what does execute nonquery returns in this case?
 Question Submitted By :: Divyaanumod
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Execute nonquery returns no. of afected rows.So if my stored procedure hav lot of select stmnt, delete stmnt, insert stmnt..then what does execute nonquery returns in this case?
Answer
# 1
Execute nonquery effects only for DML like Update delete 
and insert statements only,

for select statement we have to choose ExecuteScalar or 
ExecuteReader methods. these methods can return datareader 
and gives the result for your query.
 
Is This Answer Correct ?    7 Yes 2 No
Sandyni
 

 
 
 
Other ADO.NET Interview Questions
 
  Question Asked @ Answers
 
Explain what a diffgram is and its usage ?  1
What providers do you use to connect to oracle database ? Digital-GlobalSoft4
Which type of database is used while processing dynamic database? Microsoft1
What does ADO.NET consists of ? TCS5
Why DataReader is Forward Only? NIIT9
What providers does ado.net uses internally ? Digital-GlobalSoft2
What is datatable?  3
what are the differences between dataset and datareader? Choice-Solutions2
How you will set the datarelation between two columns?  3
What is the Magic Tables in Sqlserver2000? SQL-Star5
What is the default view of Data Grid?  3
Difference between ADO and ADO.net ? Accenture7
what is Sql Native Client? Gantec-Solutions4
what is data access layer? Honeywell2
Differnce between Stored procedure and user defined functions? Microsoft14
what is different between SqlCommand object and Command Behaviour Object  3
What is datacolumn and how it is used?  2
What are the three Ado objects? Microsoft5
can anybody show me the structure of ADO.NET  1
If we want to connect to many databases in dataaccess layer such as MSAccess,Sql server,oracle means not to a particular database depends on condition we have to connect to appropriate database in this scenario if we without changing code Ho wdo you handle this situation? Honeywell4
 
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