ExecuteScalar Method

Executes the query, and returns the first column of the first row in the result set returned by the query. Note that extra columns and/or rows are ignored.

Syntax

Visual Basic
C#
Delphi
JScript
Managed Extensions for C++

'Declaration
 
Public Overrides NotOverridable Function ExecuteScalar() As Object

public override object ExecuteScalar()

public function ExecuteScalar(): TObject; override;

public override function ExecuteScalar() : Object;

public: Object* ExecuteScalar(); override

Return Value

The first column of the first row in the result set. If the result set is empty, a null reference is returned.

Exceptions

Exception	Description
System.InvalidOperationException	The Connection is not Open or statement is being used after Leave Retain.
MimerException	A database server error occurred while executing the statement.
System.ArgumentOutOfRangeException	The data value of a parameter value was too large or too small to be converted to the database type.
System.InvalidCastException	The format of the value of one of the Parameters was invalid, or the application data type can not be converted to the target database type.

Requirements

.NET Framework
Version 2.0 or later

Reference

MimerCommand Class
MimerCommand Members