Executes a statement that does not return a result set, such as a SQL INSERT, DELETE, or UPDATE statement.
NotOverridable Public Function ExecuteNonQuery() As Integer _
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.