GeekInterview.com
Series: Subject: Topic:
Question: 643 of 648

What is the difference between excute query and excute nonquery.?

Asked by: Interview Candidate | Asked on: Jun 21st, 2005
Showing Answers 1 - 6 of 6 Answers
nidhi

Answered On : Sep 17th, 2005

Execute Query  is the  method which is used to  return the  result of the command like select Query. That is Update Query. The Execute Non Query is used  to  return the Query os the statement  like the update Delete Insert which returns No data

  
Login to rate this answer.
Kalyan

Answered On : Apr 16th, 2007

Dear nidhi,There is no method named execute Query in Ado.net.There are four methods which can be applied on command objects, execureReader,ExecuteNonQuery,ExecuteScalar, and ExecuteXmlReader.I think the person who asked this question is unaware of this.Thanks

  
Login to rate this answer.
Swathi

Answered On : Jun 27th, 2007

Execute Query is mainly used for retrieving data i.e for the select statements and Execute non query is used for insert,update statements.

  
Login to rate this answer.
ravindra sah

Answered On : Aug 2nd, 2007

Exec querey always shows data in grid but non query always shows information as messsage not in grid

  
Login to rate this answer.
BIZ

Answered On : Aug 31st, 2007

ExecuteQuery will be used to select and Exectenonquery will be used for Insert/Update/Delete

  
Login to rate this answer.
swapnali mahajan

Answered On : Aug 31st, 2007

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.