Dynamicweb 8 Documentation
ExecuteNonQuery(String,Int32,IDbConnection) Method
Example 

The SQL to execute against the database
The wait time before terminating the attempt to execute a command and generating an error. The default is 30 seconds.
Existing database connection.
Executes an SQL statement against the Connection object of a .NET Framework data provider, and returns the number of rows affected.
Syntax
'Declaration
 
Public Overloads Shared Function ExecuteNonQuery( _ 
   ByVal sql As String, _ 
   ByVal commandTimeout As Integer, _ 
   ByVal connection As IDbConnection _ 
) As Integer
public static int ExecuteNonQuery( 
   string sql,
   int commandTimeout,
   IDbConnection connection 
)

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.
connection
Existing database connection.

Return Value

The number of rows affected.
Example
Using ExecuteNonQueryUsing ExecuteNonQuery
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

See Also

Reference

Database Class
Database Members
Overload List

Send Feedback