AdoDataConnectionExecuteScalar(Type, Object, 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 returnType, substituting defaultValue if Value is retrieved.

Definition

Namespace: Gemstone.Data
Assembly: Gemstone.Data (in Gemstone.Data.dll) Version: 1.0.110 -- Release Build+b4bcf74734aa051a9b802d8f3f6ec05bd02af749
public Object? ExecuteScalar(
	Type returnType,
	Object? defaultValue,
	int timeout,
	string sqlFormat,
	params Object?[] parameters
)

Parameters

returnType  Type
The type to which the result of the query should be converted.
defaultValue  Object
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 IDbDataParameter parameters.

Return Value

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

See Also