Why the "Non" in "ExecuteNonQuery"?

Posted by Camilo Martin on Stack Overflow See other posts from Stack Overflow or by Camilo Martin
Published on 2010-05-14T12:26:51Z Indexed on 2010/05/14 12:34 UTC
Read the original article Hit count: 221

Filed under:

.NET

|

oledbcommand

|

sqlcommand

|

dbcommand

|

executenonquery

I know this is not a hell of an useful question but I can't help being bugged by it.

So,
Why said method (in *Command classes) is called
ExecuteNonQuery instead of ExecuteQuery?

Aren't those SQL statements we throw at DBs, queries?

© Stack Overflow or respective owner

Related posts about .NET

Apt-Get Update: failure to fetch; can't connect to any sources

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I realize there are dozens of "apt-get update: failure to fetch" questions (I read through all I could find), but my present circumstance is unique to 12.04 and it affects all sources; not just launchpad. Additionally, I've tried several different servers in Europe and the U.S. as well as the "main… >>> More
12.04: Apt-Get Update: failure to fetch; can't connect to any sources

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I realize there are dozens of "apt-get update: failure to fetch" questions (I read through all I could find), but my present circumstance is unique to 12.04 and it affects all sources; not just launchpad. Additionally, I've tried several different servers in Europe and the U.S. as well as the "main… >>> More
What's New in ASP.NET 4

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
The .NET Framework version 4 includes enhancements for ASP.NET 4 in targeted areas. Visual Studio 2010 and Microsoft Visual Web Developer Express also include enhancements and new features for improved Web development. This document provides an overview of many of the new features that are included… >>> More
.NET Reflector 6, .NET Reflector Pro, TestDriven.NET, .NET 4.0 and Mono

as seen on Simple Talk - Search for 'Simple Talk'
By now you may well have noticed that .NET Reflector 6 and .NET Reflector Pro are out in the wild. The official launch happened today, although we actually put the software out last Thursday as part of a phased release plan to ensure that everything went smoothly today which, so far, it seems to have… >>> More
Redmine on Apache2 with Passenger issue

as seen on Server Fault - Search for 'Server Fault'
I installed Redmine and run it in Apache2 with the Passenger module. Apache2 boots, Passenger module gets loaded and the Redmine welcome page is shown, however when trying to login or navigate to other parts of the Redmine site, the browser keeps loading and loading and loading forever, although the… >>> More

Related posts about oledbcommand

VB.Net: exception on ExecuteReader() using OleDbCommand and Access

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi again all, im getting the error below for this SQL statement in VB.Net 'Fill in the datagrid with the info needed from the accdb file 'to make it simple to access the db connstring = "Provider=Microsoft.ACE.OLEDB.12.0;Data " connstring += "Source=" & Application.StartupPath &… >>> More
Exception on ExecuteReader() using OleDbCommand and Access

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi again all, I'm getting the error below for this SQL statement in VB.Net 'Fill in the datagrid with the info needed from the accdb file 'to make it simple to access the db connstring = "Provider=Microsoft.ACE.OLEDB.12.0;Data " connstring += "Source=" & Application.StartupPath… >>> More
Reading from excel using oledbcommand

as seen on Stack Overflow - Search for 'Stack Overflow'
In the below code instead of specifying the tab name.. Is there anyway we can just say "select * from [tab1]"? what ever the tab name might be.. OleDbCommand excelOledbCommand = new OleDbCommand("Select * From [Sheet1$]", excelOledbCon); >>> More
Does the Microsoft SQL Server native client support IDBAsynchNotify?

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm working on some OLE DB code that runs queries on MS SQL Server via ICommand::Execute. I'm converting this code to operate asynchronously by setting the DBPROPVAL_ASYNCH_INITIALIZE property on the command before executing. I'd prefer to register a IDBAsynchNotify sink so that my code can be notified… >>> More
ADO.NET Command Classes - ExecuteNonQuery Method

as seen on Stack Overflow - Search for 'Stack Overflow'
I've heard that Microsoft accepts that the name of ExecuteNonQuery method of command classes was given inappropriate. Is there any official information about it, or it is just a rumour? >>> More