Gemstone Data Library
Show/Hide TOC

# AdoDataConnectionExecuteNonQuery(String, Object) Method

Executes the SQL statement using Connection, and returns the number of rows affected.

## Definition

Namespace: Gemstone.Data
Assembly: Gemstone.Data (in Gemstone.Data.dll) Version: 1.0.160 -- Release Build+0b65775365098d82320afec1fcaed7affaca67e3
C#
View Source Request Example

    public int ExecuteNonQuery(
    	string sqlFormat,
    	params Object?[] parameters
    )

VB
View Source Request Example

    Public Function ExecuteNonQuery (
    	sqlFormat As String,
    	ParamArray parameters As Object()
    ) As Integer

C++
View Source Request Example

    public:
    int ExecuteNonQuery(
    	String^ sqlFormat,
    	... array<Object^>^ parameters
    )

JavaScript
View Source Request Example

    function ExecuteNonQuery(sqlFormat, ... parameters);

#### Parameters

sqlFormat String
  Format string for the SQL statement to be executed.
parameters Object
  The parameter values to be used to fill in DbParameter parameters.

#### Return Value

Int32
The number of rows affected.

## See Also

#### Reference

AdoDataConnection Class
ExecuteNonQuery Overload
Gemstone.Data Namespace