ExecuteNonQuery Method

Executes the current SQL statement using the current connection and returns the number of rows affected.

Syntax

'Declaration
 
Public Overrides NotOverridable Function ExecuteNonQuery() As Integer

public override int ExecuteNonQuery()

public function ExecuteNonQuery(): Integer; override;

public override function ExecuteNonQuery() : int;

public: int ExecuteNonQuery(); override

Number of rows affected.

Exceptions

Exception	Description
System.InvalidOperationException	The Connection is not Open or statement is being used after Leave Retain.
MimerException	A database server error occurred while executing the statement.
System.ArgumentOutOfRangeException	The data value of a parameter value was too large or too small to be converted to the database type. This exception is also given when dealing with floating point not-a-number (NAN) value.
System.InvalidCastException	The format of the value of one of the Parameters was invalid, or the application data type can not be converted to the target database type.

Requirements

.NET Framework
Version 2.0 or later