Gemstone Data Library
Show/Hide TOC

# AdoDataConnectionExecuteScalar T(T, Int32, 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 as type T, substituting defaultValue if Value is retrieved.

## Definition

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

    public T ExecuteScalar<T>(
    	T defaultValue,
    	int timeout,
    	string sqlFormat,
    	params Object?[] parameters
    )

VB
View Source Request Example

    Public Function ExecuteScalar(Of T) (
    	defaultValue As T,
    	timeout As Integer,
    	sqlFormat As String,
    	ParamArray parameters As Object()
    ) As T

C++
View Source Request Example

    public:
    generic<typename T>
    T ExecuteScalar(
    	T defaultValue,
    	int timeout,
    	String^ sqlFormat,
    	... array<Object^>^ parameters
    )

JavaScript
View Source Request Example

    JavaScript does not support generic types or methods.

#### Parameters

defaultValue T
  The value to be substituted if Value is retrieved.
timeout Int32
  The time in seconds to wait for the SQL statement to execute.
sqlFormat String
  Format string for the SQL statement to be executed.
parameters Object
  The parameter values to be used to fill in DbParameter parameters.

#### Type Parameters

T

  [Missing <typeparam name="T"/> documentation for "M:Gemstone.Data.AdoDataConnection.ExecuteScalar``1(``0,System.Int32,System.String,System.Object[])"]

#### Return Value

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

## See Also

#### Reference

AdoDataConnection Class
ExecuteScalar Overload
Gemstone.Data Namespace