AdoDataConnectionExecuteScalar(Type, 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.

Namespace: GSF.Data
Assembly: GSF.Core (in GSF.Core.dll) Version: 2.4.181-beta

Syntax

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

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

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

member ExecuteScalar : 
        returnType : Type * 
        sqlFormat : string * 
        parameters : Object[] -> Object

function ExecuteScalar(returnType, sqlFormat, ... parameters);

returnType Type: The type to which the result of the query should be converted.
sqlFormat String: Format string for the SQL statement to be executed.
parameters Object: The parameter values to be used to fill in IDbDataParameter parameters.

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