ExecuteScalar Method (sqlFormat, args)

Deployment Tools Foundation ExecuteScalar Method (sqlFormat, args)

Executes the specified SQL SELECT query and returns a single result.

Declaration Syntax

Visual Basic

Visual C++

public Object ExecuteScalar(
	string sqlFormat,
	params Object[] args
)

Public Function ExecuteScalar ( 
	sqlFormat As String,
	ParamArray args As Object()
) As Object

public:
Object^ ExecuteScalar(
	String^ sqlFormat, 
	... array<Object^>^ args
)

member ExecuteScalar : 
        sqlFormat : string * 
        args : Object[] -> Object

Parameters

Return Value

Object
First field of the first result

Remarks

The sqlFormat parameter is formatted using Format(String, array<Object>[]()[][]).

Exceptions

Exception	Condition
BadQuerySyntaxException	the SQL syntax is invalid
InstallerException	the View could not be executed or the query returned 0 results
InvalidHandleException	the Database handle is invalid

Assembly: Microsoft.Deployment.WindowsInstaller (Module: Microsoft.Deployment.WindowsInstaller.dll) Version: 3.0.0.0 (3.11.1.2318)