Click to Rate and Give Feedback
MSDN
MSDN Library
.NET Development
.NET Framework 3.5
OleDbCommand Class
 ExecuteNonQuery Method

  Switch on low bandwidth view
This page is specific to
Microsoft Visual Studio 2008/.NET Framework 3.5

Other versions are also available for the following:
.NET Framework Class Library
OleDbCommand..::.ExecuteNonQuery Method

Executes an SQL statement against the Connection and returns the number of rows affected.

Namespace:  System.Data.OleDb
Assembly:  System.Data (in System.Data.dll)
Visual Basic (Declaration)
Public Overrides Function ExecuteNonQuery As Integer
Visual Basic (Usage)
Dim instance As OleDbCommand
Dim returnValue As Integer

returnValue = instance.ExecuteNonQuery()
C#
public override int ExecuteNonQuery()
Visual C++
public:
virtual int ExecuteNonQuery() override
JScript
public override function ExecuteNonQuery() : int

Return Value

Type: System..::.Int32
The number of rows affected.

Implements

IDbCommand..::.ExecuteNonQuery()()()
IDbCommand..::.ExecuteNonQuery()()()
ExceptionCondition
InvalidOperationException

The connection does not exist.

-or-

The connection is not open.

-or-

Cannot execute a command within a transaction context that differs from the context in which the connection was originally enlisted.

You can use the ExecuteNonQuery to perform catalog operations, for example, to query the structure of a database or to create database objects such as tables, or to change the data in a database without using a DataSet by executing UPDATE, INSERT, or DELETE statements.

Although the ExecuteNonQuery returns no rows, any output parameters or return values mapped to parameters are populated with data.

For UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the command. For all other types of statements, the return value is -1. If a rollback occurs, the return value is also -1.

The following example creates an OleDbCommand and then executes it using ExecuteNonQuery. The example is passed a string that is an SQL statement such as UPDATE, INSERT, or DELETE, and a string to use to connect to the data source.

Visual Basic
Private Sub CreateOleDbCommand( _
    ByVal queryString As String, ByVal connectionString As String)
    Using connection As New OleDbConnection(connectionString)
        connection.Open()
        Dim command As New OleDbCommand(queryString, connection)
        command.ExecuteNonQuery()
    End Using
End Sub

C#
static private void CreateOleDbCommand(
    string queryString, string connectionString)
{
    using (OleDbConnection connection = new 
               OleDbConnection(connectionString))
    {
        connection.Open();
        OleDbCommand command = new 
            OleDbCommand(queryString, connection);
        command.ExecuteNonQuery();
    }
}

Windows 7, Windows Vista, Windows XP SP2, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP Starter Edition, Windows Server 2008 R2, Windows Server 2008, Windows Server 2003, Windows Server 2000 SP4, Windows Millennium Edition, Windows 98

The .NET Framework and .NET Compact Framework do not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

.NET Framework

Supported in: 3.5, 3.0, 2.0, 1.1, 1.0
Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
Processing
© 2009 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Page view tracker