ExecuteNonQuery(String,Int32,Boolean,String) Method

Executes an SQL statement against the Connection object of a .NET Framework data provider, and returns the number of rows affected.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Shared Function ExecuteNonQuery( _ 
   ByVal sql As String, _ 
   ByVal commandTimeout As Integer, _ 
   ByVal useTransaction As Boolean, _ 
   ByVal database As String _ 
) As Integer

public static int ExecuteNonQuery( 
   string sql,
   int commandTimeout,
   bool useTransaction,
   string database 
)

Parameters

sql: The SQL to execute against the database
commandTimeout: The wait time before terminating the attempt to execute a command and generating an error. The default is 30 seconds.
useTransaction: If set to true the query is executed in a transaction.
database: Name of the MS Access database to get the data from (I.e. "Access.mdb" in /Database directory). Ignored if solution is running MS SQL-Server

Return Value

The number of rows affected.

Example

Using ExecuteNonQueryUsing ExecuteNonQuery

C#
Visual Basic

namespace Dynamicweb.Examples.CSharp
{
    class DatabaseExecute
    {

        public void ExecuteSample()
        {
            //ExecuteScalar
            var pageCount = Input.FormatInteger(Database.ExecuteScalar("SELECT COUNT(PageID) FROM Page"));

            //ExecuteScalar on alternate database
            var userCount = Input.FormatInteger(Database.ExecuteScalar("SELECT COUNT(AccessUserID) FROM AccessUser"));

            //ExecuteNonQuery
            var numberOfPagesDeleted = Database.ExecuteNonQuery("DELETE FROM Page WHERE PageID < 101");

            //ExecuteNonQuery on alternate database
            var numberOfUsersDeleted = Database.ExecuteNonQuery("DELETE FROM AccessUser WHERE AccessUserID < 101", "Access.mdb");

        }

    }
}

Public Class DatabaseExecute
    Public Sub ExecuteSample()

        'ExecuteScalar
        Dim pageCount As Integer = Input.FormatInteger(Database.ExecuteScalar("SELECT COUNT(PageID) FROM Page"))

        'ExecuteScalar on alternate database
        Dim userCount As Integer = Input.FormatInteger(Database.ExecuteScalar("SELECT COUNT(AccessUserID) FROM AccessUser"))

        'ExecuteNonQuery
        Dim numberOfPagesDeleted As Integer = Database.ExecuteNonQuery("DELETE FROM Page WHERE PageID < 101")

        'ExecuteNonQuery on alternate database
        Dim numberOfUsersDeleted As Integer = Database.ExecuteNonQuery("DELETE FROM AccessUser WHERE AccessUserID < 101", "Access.mdb")

    End Sub
End Class

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

Database Class
Database Members
Overload List