Gemstone Data Library
Show/Hide TOC

# AdoDataConnectionExecuteScalar(String, Object) Method

Executes the SQL statement using Connection, and returns the value in the first column of the first row in the result set.

## Definition

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

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

VB
View Source Request Example

    Public Function ExecuteScalar (
    	sqlFormat As String,
    	ParamArray parameters As Object()
    ) As Object

C++
View Source Request Example

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

JavaScript
View Source Request Example

    function ExecuteScalar(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

Object
Value in the first column of the first row in the result set.

## See Also

#### Reference

AdoDataConnection Class
ExecuteScalar Overload
Gemstone.Data Namespace