ExecuteScalar Method (MySqlConnection, String)

MySQL Connector/Net

Execute a single command against a MySQL database.

Namespace:  MySql.Data.MySqlClient
Assembly:  MySql.Data (in MySql.Data.dll) Version: 6.2.2.0

Syntax

C#
public static Object ExecuteScalar(
	MySqlConnection connection,
	string commandText
)
Visual Basic (Declaration)
Public Shared Function ExecuteScalar ( _
	connection As MySqlConnection, _
	commandText As String _
) As Object
Visual C++
public:
static Object^ ExecuteScalar(
	MySqlConnection^ connection, 
	String^ commandText
)

Parameters

connection
Type: MySql.Data.MySqlClient..::.MySqlConnection
MySqlConnection object to use
commandText
Type: System..::.String
Command text to use for the command

Return Value

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

See Also