AdoDataConnectionExecuteScalar(Type, Object, 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.128 -- Release Build+cb657b646daac3e9cc5384ff42ed4530df50eab1

C#View Source Request Example

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

VBView Source Request Example

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

C++View Source Request Example

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

JavaScriptView Source Request Example

function ExecuteScalar(returnType, defaultValue, sqlFormat, ... 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.
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.

AdoDataConnectionExecuteScalar(Type, Object, String, Object) Method

Definition

Parameters

Return Value

See Also

Reference