Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

ExecuteNonQuery method

Executes a statement that does not return a result set, such as a SQL INSERT, DELETE, or UPDATE statement.

Visual Basic

NotOverridable Public Function ExecuteNonQuery() As Integer _
Implements IDbCommand.ExecuteNonQuery

C#

public int ExecuteNonQuery();

The number of rows affected.

The statement is the current ULCommand object, with the ULCommand.CommandText and ULCommand.Parameters as needed.

For UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the command. For all other types of statements, and for rollbacks, the return value is -1.

The ULCommand.CommandType cannot be System.Data.CommandType.TableDirect.

• ULException class - A SQL error occurred.

•  InvalidOperationException - The command is in an invalid state. Either the ULCommand.Connection is missing or closed, the ULCommand.Transaction value does not match the current transaction state of the connection, or the ULCommand.CommandText is invalid.

 IDbCommand.ExecuteNonQuery

• ULCommand class
• ULCommand members
• CommandText property
• Parameters property
• CommandType property
•  CommandType.TableDirect
• Connection property
• Transaction property
• CommandText property