Executes the SQL query in the sql parameter against the database. Use this method when the sql query does not return a result set (e.g., INSERT, UPDATE, or some stored procs). Otherwise, use ExecuteQuery(CommandType, String, array<SqlParameter>[]()[][]) if a result set is desired.

Namespace: Asi.iBO
Assembly: Asi.iBO (in Asi.iBO.dll) Version: 15.1.3.0

Syntax

C#
public int ExecuteNonQuery(
	CommandType commandType,
	string sql,
	SqlParameter[] commandParameters
)
Visual Basic
Public Function ExecuteNonQuery ( _
	commandType As CommandType, _
	sql As String, _
	commandParameters As SqlParameter() _
) As Integer
Visual C++
public:
int ExecuteNonQuery(
	CommandType commandType, 
	String^ sql, 
	array<SqlParameter^>^ commandParameters
)

Parameters

commandType
Type: System.Data..::..CommandType
The type of cammand contained in the sql parameter.
sql
Type: System..::..String
The SQL command to execute
commandParameters
Type: array<System.Data.SqlClient..::..SqlParameter>[]()[][]
The parameters to be bound to the query

Return Value

The number of rows affected by the query

See Also