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) if a result set is desired.
Namespace:
Asi.iBOAssembly: Asi.iBO (in Asi.iBO.dll) Version: 15.1.2.0
Syntax
| C# |
|---|
public int ExecuteNonQuery( CommandType commandType, string sql, SqlParameter[] commandParameters ) |
| Visual Basic (Declaration) |
|---|
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