Contents Index DesignTimeVisible property ExecuteReader method

ASA Programming Guide
  Adaptive Server Anywhere .NET Data Provider API Reference
    AsaCommand class

ExecuteNonQuery method


Description 

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

Syntax 

int ExecuteNonQuery( )

Return value 

The number of rows affected.

Implements 

IDbCommand.ExecuteNonQuery

Usage 

You can use ExecuteNonQuery to change the data in a database without using a DataSet. Do this by executing UPDATE, INSERT, or DELETE statements.

Although ExecuteNonQuery does not return any rows, output parameters or return values that are mapped to parameters are populated with data.

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.


Contents Index DesignTimeVisible property ExecuteReader method