DataSource.ExecuteScalar(T) Method (String, TransactionContext, T)

System.Data.Generic

previous page next page

System.Data.Generic

DataSourceExecuteScalarT Method (String, TransactionContext, T)

Executes the query, and returns the first column of the first row in the result set returned by the query. Supports transactions.

Namespace: System.Data.Generic
Assembly: System.Data.Generic (in System.Data.Generic.dll) Version: 1.9.5473.30542 (1.9.5473.2392)

Syntax

C++

Copy

public T ExecuteScalar<T>(
	string SQL,
	TransactionContext transaction,
	T defaultValue
)

Public Function ExecuteScalar(Of T) ( 
	SQL As String,
	transaction As TransactionContext,
	defaultValue As T
) As T

public:
generic<typename T>
T ExecuteScalar(
	String^ SQL, 
	TransactionContext^ transaction, 
	T defaultValue
)

member ExecuteScalar : 
        SQL : string * 
        transaction : TransactionContext * 
        defaultValue : 'T -> 'T

Parameters

SQL: Type: SystemString
Transact-SQL statement to execute against the connection.
transaction: Type: System.Data.GenericTransactionContext
Context of the transaction.
defaultValue: Type: T
Default value to return in case of no return.

Type Parameters

T: Type to return.

Return Value

Type: T
The first column of the first row in the result set, or a null reference (Nothing in Visual Basic) if the result set is empty. Returns a maximum of 2033 characters.

Exceptions

Exception	Condition
ArgumentNullException	In case the SQL is null.
SqlException	In case the underlying connection cause an exception.

Remarks

Reference

DataSource Class

ExecuteScalar Overload

System.Data.Generic Namespace

previous page start next page