Click or drag to resize
DataAccessExecuteScalar Method (String, Hashtable, Object)
Executes the query, and returns the first column of the first row in the result set returned by the query. Extra columns or rows are ignored

Namespace: WorkflowGen.My.Data
Assembly: WorkflowGen.My (in WorkflowGen.My.dll) Version: 3.3.0.0 (3.3.0.0)
Syntax
Copy
public Object ExecuteScalar(
	string sqlQuery,
	Hashtable parameters,
	Object defaultValue
)

Parameters

sqlQuery
Type: SystemString
A SQL statement to execute
parameters
Type: System.CollectionsHashtable
A parameters collection
defaultValue
Type: SystemObject
A default value returned if the result is null

Return Value

Type: Object
The first column of the first row in the result set, or a null reference if the result set is empty
See Also