MySqlCommand.ExecuteScalar Method

MySQL Connector/Net

previous page next page
MySqlCommandExecuteScalar Method
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: MySql.Data.MySqlClient
Assembly: MySql.Data (in MySql.Data.dll) Version: 6.9.9
Syntax
Copy
public override Object ExecuteScalar()
Public Overrides Function ExecuteScalar As Object
public:
virtual Object^ ExecuteScalar() override
abstract ExecuteScalar : unit -> Object 
override ExecuteScalar : unit -> Object

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

Implements

IDbCommandExecuteScalar
Remarks

Use the ExecuteScalar method to retrieve a single value (for example, an aggregate value) from a database. This requires less code than using the ExecuteReader method, and then performing the operations necessary to generate the single value using the data returned by a MySqlDataReader

Examples
The following example creates a MySqlCommand and then executes it using ExecuteScalar. The example is passed a string that is a SQL statement that returns an aggregate result, and a string to use to connect to the data source.
Copy
public void CreateMySqlCommand(string myScalarQuery, MySqlConnection myConnection)
{
MySqlCommand myCommand = new MySqlCommand(myScalarQuery, myConnection);
myCommand.Connection.Open();
myCommand.ExecuteScalar();
myConnection.Close();
}
Public Sub CreateMySqlCommand(myScalarQuery As String, myConnection As MySqlConnection)
Dim myCommand As New MySqlCommand(myScalarQuery, myConnection)
myCommand.Connection.Open()
myCommand.ExecuteScalar()
myConnection.Close()
End Sub
public:
void CreateMySqlCommand(String* myScalarQuery, MySqlConnection* myConnection)
{
MySqlCommand* myCommand = new MySqlCommand(myScalarQuery, myConnection);
myCommand->Connection->Open();
myCommand->ExecuteScalar();
myConnection->Close();
}

No code example is currently available or this language may not be supported.

See Also
previous page start next page