|
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.
Namespace: GSF.DataAssembly: GSF.Core (in GSF.Core.dll) Version: 2.4.258-beta+f8b6aa3dbfe0b4cc2b0b0760dd5d2a3dd4f59d09
Syntaxpublic Object ExecuteScalar(
Type returnType,
Object defaultValue,
string sqlFormat,
params Object[] parameters
)
Public Function ExecuteScalar (
returnType As Type,
defaultValue As Object,
sqlFormat As String,
ParamArray parameters As Object()
) As Object
public:
Object^ ExecuteScalar(
Type^ returnType,
Object^ defaultValue,
String^ sqlFormat,
... array<Object^>^ parameters
)
member ExecuteScalar :
returnType : Type *
defaultValue : Object *
sqlFormat : string *
parameters : Object[] -> Object function ExecuteScalar(returnType, defaultValue, sqlFormat, ... parameters);
View SourceParameters
- 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
ObjectValue in the first column of the first row in the result set.
See Also